Home » SQL & PL/SQL » SQL & PL/SQL » Date
Date [message #186048] Sat, 05 August 2006 03:37 Go to next message
alomer
Messages: 2
Registered: August 2006
Junior Member
Hi,
How can I check the date whether it is less than the 20th of a month or not?
Thanks.

[Updated on: Sat, 05 August 2006 04:00]

Report message to a moderator

Re: Date [message #186049 is a reply to message #186048] Sat, 05 August 2006 03:44 Go to previous message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member


To_char(date_field,'dd') between '01' and '20'


TRUNC(date_field) between Trunc(date_field,'MONTH) 
                          Trunc(date_field,'MONTH) + 20 ;


Thumbs Up
Rajuvan.
Previous Topic: Could anyone please help me to solve this problem ?
Next Topic: Database Domain
Goto Forum:
  


Current Time: Thu Dec 08 16:34:52 CST 2016

Total time taken to generate the page: 0.13424 seconds