It sucks, but that's the way CF returns dates, regardless of their
formatting in the DB.
To return it usable for you, just use CF's DateFormat function:
DateFormat(dbDateField,"-mm-dd") gives you 2006-10-25
DateFormat(dbDateField,"mmm dd, ") gives you October 25, 2006
-Original Mes
DateFormat(datevar, '-mm-dd') would output 2001-01-01 just as in the
mysql database. I think date in mysql is date/time. Instead of
'-mm-dd' there are names like 'short', 'medium', 'long' and 'full'
but I don't remember off the top of my head what they output. I think
you would want
thanks very much it works fine now :)
~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionaut
That's an ODBC Date.
Just use dateFormat() to make it look however you want.
> -Original Message-
> From: Richard White [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 25, 2006 11:48 AM
> To: CF-Talk
> Subject: cf date conversion
>
> hi, i have a field saved in mysql database as a D
4 matches
Mail list logo