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 a DateFormat on #newdate#
> Is there any more elegant solutions or am I missing something obvious?
> Thanks Michael.
>
>
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
the date to ColdFusion in any format you want.
-Ryan
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260817
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
