We are in the process converting from progress 8.2 to 9 databases. I are currently using OPENLINK for progress8 as our ODBC. I having to convert to use SQL92 instead of openlink. There were several code changes I had to do for SQL92. I still have outstanding issue.
I have a field defined as VARCAR that I sending a field defined as datatime in powerbuilder. We didn't use a mask with openlink. The character field now is stored as (2006-05-30 10:57:16.440000000) using SQL92 it was storing (05/30/2006) with openlink.
datetime lt_system_date
ld_date = Today( )
lt_time = Now()
lt_system_date = Datetime(ld_date, lt_time)
I saw comments where you change the sequence of the mdy through changeing the startup.pf files. Except my .pf file has -d mdy.and I notice is shows yyyy-mm-dd So I don't believe this my issue. I really didn't want to have to change all code to use edit mask to get correct format.
Thoughts?
I have a field defined as VARCAR that I sending a field defined as datatime in powerbuilder. We didn't use a mask with openlink. The character field now is stored as (2006-05-30 10:57:16.440000000) using SQL92 it was storing (05/30/2006) with openlink.
datetime lt_system_date
ld_date = Today( )
lt_time = Now()
lt_system_date = Datetime(ld_date, lt_time)
I saw comments where you change the sequence of the mdy through changeing the startup.pf files. Except my .pf file has -d mdy.and I notice is shows yyyy-mm-dd So I don't believe this my issue. I really didn't want to have to change all code to use edit mask to get correct format.
Thoughts?