converting SQL database timestamp in cold fusion

Cold fusion, timestamp, convert to string

[CaptnGordo]

Hi all,

does anybody have an example of how to convert a SQL timestamp into a date I can display and sort by with cold fusion?

Thanks,

Gordo

[Sanenet]

Yeah, just use Dateformat. So,
#DateFormat('sqltimestamp', 'dd of mmmm, yyyy')#