> further research indicates that for PG I could trysomething like: > > SELECT EXTRACT(MONTH FROM TIMESTAMP)
I'm sure there is a NOW() or TIME() function in PG that returns the current date/time. Then you could do this: SELECT * FROM your_table WHERE EXTRACT(MONTH FROM your_column) = EXTRACT(MONTH FROM PG_CURRENT_TIME_FUNCTION()); > $today = getdate(); > $start = $today['year'] . '-' . $today['mon'] . '-' . '01'; > $end = $today['year'] . '-' . $today['mon'] . '-' . '31'; > > "SELECT * FROM guest WHERE pdate BETWEEN {$start} AND {$end}"; > > but PG doesn't like my format of $pdate as type date, since the result for > $start and $end seems to result in type integer. Sigh. I think PG uses the unix timestamp format, the number of seconds since Jan 1, 1970 or something. You could use a combination of date() and mktime() and maybe even strtotime() to figure the unix timestamp of the current month's start and end, then use the BETWEEN SQL given above... ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php