Date convert Problem

September 10th, 2004, 08:47 AM

Hi, everyone
Does anyone knows how to convert from e.g. 1094774400 to 10/09/2004 00:00:00(today's date UK format), I am trying to write report basic on these numbers.

Many thanks.

Peter

jmaronilla · September 10th, 2004, 05:03 PM

Peter,
Try this format:

yyyy/mm/dd hh:nn:ss

Let me know if it works.
John

egivler · September 10th, 2004, 09:59 PM

The question is, what does that number represent? It looks like it might be a unix timestamp (seconds since 1970), but could be something else. Once you give that info, it might be easier.

jmaronilla · September 13th, 2004, 02:15 PM

The number is generally represented as a Unix timestamp: the number of seconds since January 1, 1970 00:00:00 Greenwich Mean Time.
John