i want 2 campare two dates in sql. i.e comparing sysdate with the date driven from database. actually i am having date field in my database and i want 2 get the datas in which date should be 14 days less than sysdate.
I thought this was going to be something along the lines of:
"I have a bunch of girls that I have dated, and I want to store the results of the dates in SQL.
Does anyone know what would be a good Primary Key for them? Some of the girls have been on more than one date with me, so I think I need some kind of relationship, but I don't want to get into a commitment. Also, I have never had a chance at a one to many relationship before, can any of you guys reccommend it?"
Now that would be an SQL Date Comparison I would like to see the results of. [img]images/icons/smile.gif[/img]
Software Test Engineer
If builders built buildings the way programmers wrote programs, then the first woodpecker that came along would destroy civilization.