[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Julian Date in SQL Server
- Subject: Julian Date in SQL Server
- From: Martin Chou <martin.chou@INS.COM>
- Date: Wed, 10 Feb 1999 17:40:06 -0800
I am currently using the function DATEPART in this format
DATEPART(DY,GETDATE()) to get my julian date. This actually works fine
but I need to pass a variable in place of the GETDATE(). Thus, I am
trying to use this syntax DATEPART(DY,$DATE). The variable type that I
am using is $ and the variable date format is YYMMDD. Unfortunately,
the SQR doesn't seem to like the variable. Any suggestions on why this
doesn't work? Thanx.
Martin