Re: timestamp value management

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



So, you want the maximum date of the result set? Just use SQL:

select max(datecolumn) from table where (conditions);

-Micah 


On Monday 30 January 2006 1:03 pm, xkorakidis wrote:
> hi guys!
> I'm trying to manage a table containing a timestamp colum
> - when I insert a record, I don't fill a value in timestamp column, so
> current timestamp is inserted. The inserted value is smth like
> 20060129213253
> - when I try to show this value in a php page, I use
> date($varOfTimestampColumn) or getdate(). The final result is the
> highest possible date (smth like January 19 2038 I think)
>
> How can I manage the timestamp field so as to show the correct value?
> Thanks!

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux