You can use the dayname(timestamp) or dayofweek(timestamp) function.
e.g., select dayname(current_date) from blah will give you "Tuesday".
select dayofweek(current_date) from blah will give you 3.
-----Original Message-----
From: Alan Davenport [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 25, 2001 11:17 AM
To: [EMAIL PROTECTED]
Subject: Day of Week Select Statement
Is it possible to get the current day of the week (Alpha) by using a select
statement? I'm writing some scripts and it will simplify things if I can
tell the day of the week from within the script(s).
Alan Davenport
Senior Storage Administrator
Selective Insurance
[EMAIL PROTECTED]
(973)948-1306
