Date Format for TIMESTAMP

[Anon]

Dear friends,

i am facing a problem while geting date from field timestamp.

i get date in yyyymmddhhmmss format and i have given a function for date format

$fdate=date("d-m-Y",($row->data));

i get a result 01-01-1970

please help me out

Regard,
Sayed Zahid Ali Rizvi.

[ccgorman]

Check out the mktime function:

http://www.php.net/manual/en/function.mktime.php

int mktime (int hour, int minute, int second, int month, int day, int year [, int is_dst])

i.e.

date ("d-m-Y", mktime(0,0,0,1,1,1970))

You will need to format the timestamp field using substr.

This may help,
David