Under the Unix environment there is the "date" command
zdec23@tsmutl01/home/zdec23/bin > date +%a
Tue
zdec23@tsmutl01/home/zdec23/bin > date +%A
Tuesday
zdec23@tsmutl01/home/zdec23/bin >
I use that a lot in scripts...

Dwight

-----Original Message-----
From: Alan Davenport [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 25, 2001 10: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

Reply via email to