European Date format

[ChefSausage]

Is there a way to have a formfield of european date formatted text be stored as such, so it outputs in the sameformat? When I output it from the database it's reversing the month and day back to US standard.

 

[r937]

since almost every database stores dates as integer numbers, the choice of which format to display it in is usually a settable default in the database, plus, you can use formatting functions in the sql(e.g. FORMAT() in access, CONVERT() in sql server, TO_CHAR in oracle), or, alternatively, if you choose to return an actual date object in the result set, you can then use coldfusion's
DateFormat function

but, to recap, dates are not stored in any particular format, they are stored as the number of days since january 1, 1573, or some such (depends on the database)


rudy

http://r937.com/

 

[ChefSausage]

Thank you for the info. I don't know the syntax for the CONVERT() function, but the date format in CF works all the same. Just wanted to make sure I wasn't missing any crucial information.

 

[r937]

CAST and CONVERT

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp

rudy