Re: Help with a postgreSQL-query

1998-02-06 Thread office
PLEASE REMOVE THE ADDRESSES [EMAIL PROTECTED] [EMAIL PROTECTED] or any freetech-mall.com address !! DO IT NOW I DONT WANT TO READ THIS AND I NEVER wanted ! STefan GAertner -- TO UNSUBSCRIBE FROM THIS MAILING LIST: e-mail the word "unsubscribe" to [EMAIL PROTECTED] . Trouble? e-mail to [EMAIL

Re: Help with a postgreSQL-query

1998-02-04 Thread Dave Mitchell
This sounds more like an SQL question to me. I don't have postgres, but on informix there's a day() function for dates so I can do this: SELECT * FROM agenda_items WHERE day(itemdate)=15; (where itemdate is a DATETIME field) -dave m.