469,128 Members | 1,611 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,128 developers. It's quick & easy.

validation of only dd in DD/MM/YYYY date format

1
Hi,
I've an issue regarding validation of dates in which I have to validate against only dates and not month & year.For e.g I've to hard code the days - 16th of one month & 15th of next month be it any month & year.So how to write a query for it?
I'll give you an e.g :- a person has to fill in some claims in an office whose period starts from 15th of one month & 16th of next month.If he/she fills the claim for say 15th of one month to 16th of next month , he/she shouldn't be able to apply for it. Can anyone help me out on this????

Its very URGENT!!!!!!!!!!!!!!!!!!!
Sep 17 '07 #1
1 2156
amitpatel66
2,367 Expert 2GB
Hi,
I've an issue regarding validation of dates in which I have to validate against only dates and not month & year.For e.g I've to hard code the days - 16th of one month & 15th of next month be it any month & year.So how to write a query for it?
I'll give you an e.g :- a person has to fill in some claims in an office whose period starts from 15th of one month & 16th of next month.If he/she fills the claim for say 15th of one month to 16th of next month , he/she shouldn't be able to apply for it. Can anyone help me out on this????

Its very URGENT!!!!!!!!!!!!!!!!!!!
Check below Query:

SELECT TO_CHAR(<date_column>,'DD') FROM <table_name>
Sep 17 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Abby Lee | last post: by
reply views Thread by Brian Conway | last post: by
5 posts views Thread by JIM.H. | last post: by
12 posts views Thread by Diego | last post: by
1 post views Thread by Brendan Reynolds | last post: by
Stang02GT
5 posts views Thread by Stang02GT | last post: by
5 posts views Thread by maz77 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.