Viewing 2 posts - 1 through 3 (of 3 total)
Yes, you are right,The 'DATE' datatype is exists on SQL Server 2005/2008 but i told that in below QUERY
DECLARE @Today DATE
SELECT @Today = '01 DEC 2009'
SELECT @Today+1
SELECT @Today
IF...
April 28, 2010 at 3:15 am
Hi to all,
1.
DECLARE @Today DATE
it wii not work but if you change datetype "DATE" to "DATETIME"
Then it will work
DECLARE @Today DATETIME
SELECT @Today = '01 DEC 2009'
SELECT @Today+1
SELECT @Today
2.
Directly we can't...
April 28, 2010 at 1:04 am
Viewing 2 posts - 1 through 3 (of 3 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy