php dates and postgres

From: Date: Thu, 11 Jan 2007 20:37:00 +0000
Subject: php dates and postgres
Groups: php.db 
Request: Send a blank email to php-db+get-42926@lists.php.net to get a copy of this message
Hello, I need to query my db to find out if an entry has been updated since a date the user enters (mm/dd/yyyy). Can I do something like the stuff below? Or do I need to do the extract epoch stuff backwards somehow? $timestamp = strtotime($user_date); $postgres_format = date(format info that matches the postgres format, $timestamp); and then use $postgres_format to see if something is newer/older when I do my SQL? When I enter things can I use something similar (if I can't use now())? Thanks! Natalie

« previous php.db (#42926) next »