T-SQL Time
I want to verify the correct time in T-SQL 2000.
To specify today's date from 12AM until 11:59PM
Would it be specified like below?
For SET @startdate = '2012-12-20 00:00:00'
SET @enddate = '2012-12-20 23:59:59'
I want to be sure about the 23:59:59 because I found some existing queries on a SQL Server 2000 and it is displayed as 00:00:00 to 11:59:59
Thanks.
To specify today's date from 12AM until 11:59PM
Would it be specified like below?
For SET @startdate = '2012-12-20 00:00:00'
SET @enddate = '2012-12-20 23:59:59'
I want to be sure about the 23:59:59 because I found some existing queries on a SQL Server 2000 and it is displayed as 00:00:00 to 11:59:59
Thanks.
Asked:
Who is Participating?
try to use SQl server function
GETDATE
select GETDATE()
2012-12-20 15:36:33.620
---
see more about GETDATE() @ http://msdn.microsoft.com/en-US/library/ms188383(v=sql.105).aspx
--
in case you wish to be sure
that queries like this -try :
declare
@startdate as datetime,
@@enddate as datetime
set @startdate = '2012-12-20 00:00:00'
SET @enddate = '2012-12-21 00:00:00'
select * from table where DT >=@startdate And DT < @Enddate
GETDATE
select GETDATE()
2012-12-20 15:36:33.620
---
see more about GETDATE() @ http://msdn.microsoft.com/en-US/library/ms188383(v=sql.105).aspx
--
in case you wish to be sure
that queries like this -try :
declare
@startdate as datetime,
@@enddate as datetime
set @startdate = '2012-12-20 00:00:00'
SET @enddate = '2012-12-21 00:00:00'
select * from table where DT >=@startdate And DT < @Enddate
or
use Datediff function'
declare
@startdate as datetime,
@@enddate as datetime
set @startdate = '2012-12-20 00:00:00'
SET @enddate = '2012-12-21 00:00:00'
select * from table where DATEDIFF ( day , '2012-12-20 00:00:00' , '2012-12-20 23:00:00' )=0
---DATEDIFF http://msdn.microsoft.com/en-us/library/ms189794(v=sql.105).aspx
use Datediff function'
declare
@startdate as datetime,
@@enddate as datetime
set @startdate = '2012-12-20 00:00:00'
SET @enddate = '2012-12-21 00:00:00'
select * from table where DATEDIFF ( day , '2012-12-20 00:00:00' , '2012-12-20 23:00:00' )=0
---DATEDIFF http://msdn.microsoft.com/en-us/library/ms189794(v=sql.105).aspx
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
All Courses
From novice to tech pro — start learning today.
