Re: Need help w Powerbuilder & IFX Dates

In article <3n5qrv$b07@news.panix.com>, Mike Stenzler <mes> wrote: >Anyone have experience using Powerbuilder w/ Informix? > >I'm using PB4.0 w/ Informix SE 5.0 over TCP/IP > >Date types stored in the db as such dont work! > >I have to store as DATETIME (YEAR to DAY) & then have all kinds >of conversion, retrieval , update, insrt problems! > >Can anyone who has gone thru this help? > >Mike > I had a related problem: I had to compare a datetime field on server side INFORMIX ONLINE 7.1 with a lookup table on client side Dbase3. I store the "HH:MM:SS" part of the time as a string field on the client side. When I need to compare the two datetime values I convert the "date" portion of the datetime value and the "time" portion of the datetime value (actually a string) like this: cli_time is a variable of type "time" table_time_cli_s is a string that contains the "HH:MM:SS" The next line converts the string. cli_time = time(table_time_cli_s) table_upd_cli_dt is a datetime variable created by using the "DateTime" function table_upd_cli_dt = DateTime(table_upd_cli,cli_time) Note: table_upd_cli is the "date" variable that contains the "date" data from my table on the client side. -- ----------------------------------------------------------------------------- Do unto others ... then split! MaryAnne Stasium -----------------------------------------------------------------------------