View Single Post
  #1 (permalink)  
Old February 23rd, 2006, 08:43 AM
cathiec cathiec is offline
Authorized User
Join Date: Jun 2004
Location: , , .
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default get current month

hi all,

i need to get the current month in a query that i am writing - based on the sysdate. i was trying something like month(sysdate) but its not working.

would appreciate any help!