|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Generate data entry and reporting .NET Web apps in minutes, straight from your database. Read our FREE whitepaper “Build Web 2.0 Applications Without Hand-Coding” Download now! |
|
#1
March 6th, 2005, 11:10 PM
|
|||
|
|||
|
CreateODBCDate
Hi,
I have inserted a date into the DB using CreateODBCDate and then when I display it from the query the date is back to front. Eg 23/04/05 (or US 04/23/05) would come out as 04/05/2023 what up with that? I have used the function LSDateFormat() to convert to non US format after I have draw it out with a query, using a mask of DD/MM/YY Also I have checked using GetLocale() to see what my locale info is... If I type the date in and update the DB it displays fine, but if I load the update form and then submit it for updating in the DB without changing (ie typing anything) it comes out wrong. Any suggestions anyone?
|
|
#2
March 7th, 2005, 08:40 AM
|
|||
|
|||
|
could you show us your insert statement for the DB?
|
|
#3
March 7th, 2005, 08:56 AM
|
|||
|
|||
|
I would also specify the full year:
23/04/2005
__________________
Ask if you have a question, but also help answer questions that you have knowledge of! Thanks, Brian. How to Post a Question in the Forums
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > ColdFusion Development > CreateODBCDate |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
