Aug 29, 2002 #1 Iby Programmer Jul 17, 2002 18 0 0 IT Hello, How can I display only just the month of the systemdate? I think of like this: where (date_field, 'MM') = to_date(sysdate,'MM') Thank you in advance!
Hello, How can I display only just the month of the systemdate? I think of like this: where (date_field, 'MM') = to_date(sysdate,'MM') Thank you in advance!
Aug 29, 2002 #2 lewisp Programmer Aug 5, 2001 1,238 0 0 GB select to_char(sysdate,'Month') from dual; Upvote 0 Downvote