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

["Giri Gopal" <GiriGopal@xxxxxxxxxx>]

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