Unix Timestamp

2006-11-16 Thread Michael Wright
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

Re: Unix Timestamp

2006-11-16 Thread Ryan Stille
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

Re: Unix Timestamp

2006-11-16 Thread Charles Sheehan-MIles
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

Re: Unix Timestamp

2006-11-16 Thread Paul Hastings
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