Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › How do I convert UNIX timestamps to the date format d.m.Y inside a query

View all replies to this thread

How do I convert UNIX timestamps to the date format d.m.Y inside a query

Thread began 3/03/2010 7:51 am by Rune Brynestad | Last modified 3/04/2010 10:03 am by Rune Brynestad | 4021 views | 6 replies

3/04/2010 3:01 amRune Brynestad

Have done some more testing. From what I see, MySQL's FROM_UNIXTIME() function does not support negative epoch timestamps (just as the inverse function UNIX_TIMESTAMP() does not either).

It looks like I could use the DATE_ADD function

SELECT Name, DATE_ADD('1970-01-01', INTERVAL Date_of_birth second) As DOB FROM Test

gives me 1964-08-11 00:00:00 which is correct.

What I need now is a way to format this date the way we use it in Norway which is 11.08.1964 or dd.mm.yyyy

It still have to be done inside the query. Could it be done ?

Regards
Rune

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.