RE: can I find out if a date is Saturday or Sunday in sql

Use function DAYOFWEEK()

-----Original Message-----
From: Giri Gopal [mailto:GiriGopal@bcgink.com]
Sent: Thursday, October 31, 2002 11:00 AM
To: rpg400-l@midrange.com
Subject: can I find out if a date is Saturday or Sunday in sql

Hi:

There are couple of things I want to do in my SQL statement. Can some
one
help with this please.

Select date,time from file a

Here in the select statement above I want to do two things:

1)  check if time is 5:59 A.M i.e. if time is < 55959 then date = date
+1
2)  if date is Saturday or Sunday make the date as Friday's date.


Can this be done on the sql.

Thanks for your help in advance.

GG

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.