I've googled this but can't find what I'm looking for. I have a MySQL db
that has several date fields storing the date as a Unix timestamp and I need
to display in CF. The only thing I can think of is:
cfset newdate = DateAdd(s, #dbdate#, 01-01-70)
And then do a DateFormat on #newdate
Michael Wright wrote:
I've googled this but can't find what I'm looking for. I have a MySQL db
that has several date fields storing the date as a Unix timestamp and I need
to display in CF. The only thing I can think of is:
cfset newdate = DateAdd(s, #dbdate#, 01-01-70)
And then do
Check this function:
Epochtimetodate
http://www.cflib.org/library.cfm?ID=13
On 11/16/06 6:53 PM, Michael Wright [EMAIL PROTECTED] wrote:
I've googled this but can't find what I'm looking for. I have a MySQL db
that has several date fields storing the date as a Unix timestamp and I need
Ryan Stille wrote:
There is probably a way to do it in CF (did you try just giving it to
DateFormat() ?), but you can use the MySQL dateformat function to send
no, cf expects decimal days since 31-dec-1899 as it's numeric date data.
what you're doing is fine though keep any eye on your
4 matches
Mail list logo