Re: [PHP-DB] timestamp value management

2006-02-01 Thread Julien Bonastre
istration and their oil resource driven ambitions. Its a terrible world isn't it? As I was saying, thank God/Allah/Buddah/*insert deity here* that the mySQL and PHP doc's writers are so talented and organised! Ta ta !! - Original Message - From: "Gerry Dane

Re: [PHP-DB] timestamp value management

2006-01-29 Thread Gerry Danen
I use this function: functionxlate_datetime($in_field, $in_format) { // 2005-10-02 18:05:52 // 0123456789012345678 $year = substr( $in_field, 0, 4 ); $month = substr( $in_field, 5, 2 ); $day= substr( $in_field, 8, 2 ); $hour = su

Re: [PHP-DB] timestamp value management

2006-01-29 Thread Jan Pieper
the timestamp of mysql is only the date without any spacers. the php timestamp is a unix-timestamp (seconds since 01.01.1970) so you can´t convert your record-value to an normally date directly. you have to use split out the year, the month etc. manually. (or is there a function for it? don´t kn

Re: [PHP-DB] timestamp value management

2006-01-29 Thread Micah Stevens
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 va

[PHP-DB] timestamp value management

2006-01-29 Thread xkorakidis
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