Natalie Leotta wrote:
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())?
Depends on how you're getting the $user_date.
If you have separate form fields for mm, dd & yyyy then you can just put
it all together.
$check_date = (int)$_POST['yyyy'] . '-' . (int)$_POST['mm'] .
(int)$_POST['dd'];
If you're getting it in one form field or a weird format, you will need
to do some sort of conversion to a 'standard' format.
Then when it comes time to do the query, it's simple if you store it in
date or timestamp format, you can just do:
select * from table where createdate > 'yyyy-mm-dd';
If you store epoch timestamps, then you'll need to convert it using
strtotime.
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
