Page 1 of 1

Convert bigint830)

Posted: Sat Nov 15, 2008 4:54 am
by Arsench2000
Hello, I have a data field for date and time and it is a bigint(30), now I want to display date.
How can I convert bigint into date?

thank you

Re: Convert bigint830)

Posted: Sat Nov 15, 2008 8:33 am
by chopsmith
How did you get the bigint value in there? Is it a unix timestamp or something? If that's the case, look at these pages in the manual:

1. http://us3.php.net/manual/en/function.getdate.php
2. http://us3.php.net/date

Either one will do the trick.