[RESOLVED] php mysql timestamp conversion

[jmantra]

I am trying to write a script that will interact with the database backend of our helpdesk system.Basically their will be a form that will submit the ticket in a certain format. However I am having trouble with the timestamp field in one of the tables. When the ticket is displayed it displays the date in this format:

December 13, 2007, 4:15 am

But the timestamp field of the table displays as something totally different:

1197467908

From what I understand about timestamps in mysql, it should be something like this:

970523 or 1997-05-23

this obviousily converts to May 23, 1997.

I was trying to find the code that does that conversion in the helpdesk software, but their were different include scattered all over the place and no absolutely no documentation, plus a lot of the code is object-oriented code which is something I still can't seem to get the grasp of.

So I was wondering if anyone had any experience with this type of conversion and could help me out a bit.

Thanks in advance.

[cahva]

Its an unix timestamp(in seconds since January 1st, 1970). Mysql has functions that you can use to get it "human readable".

For example:

SELECT datefield,FROM_UNIXTIME(datefield) AS datefield_formatted FROM table;

...You will get the original timestamp and formatted date(for example 2007-01-10 20:10:12).

You can also do the conversion in PHP(I wouldnt):

$date_formatted = date("Y-m-d H:i:s",$timestamp);

Check out Mysql date and time functions.

[jmantra]

Hey,

I was able to achieve what I wanted to do using the getdate() function.

Thanks.😃