i want to ignore the time aspect. Is there any parameters you can send to getdate() to specify return of just the date?This is a discussion on i want to ignore the time aspect. Is there any parameters you can send to getdate() to specify return of just the date? within the sqlserver-server forums in Microsoft SQL Server category; Dear All, I want to compare a date with a getDate() the problem is that the getDate() returns the time too... hence 1/1/2004 >= 1/1/2004 13:21 is false... hence 1/1/2004 >= 1/1/2004 is true... i want to ignore the time aspect. Is there any parameters you can send to getdate() to specify return of just the date? Thanks harshad prajapati... | ||||||||
| | ||||||||
| ||||||||
| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
08-28-2008, 05:48 AM
|
 i want to ignore the time aspect. Is there any parameters you can send to getdate() to specify return of just the date? Dear All, I want to compare a date with a getDate() the problem is that the getDate() returns the time too... hence 1/1/2004 >= 1/1/2004 13:21 is false... hence 1/1/2004 >= 1/1/2004 is true... i want to ignore the time aspect. Is there any parameters you can send to getdate() to specify return of just the date? Thanks harshad prajapati  |
|
#2
08-28-2008, 06:06 AM
|
| Re: i want to ignore the time aspect. Is there any parameters youcan send to getdate() to specify return of just the date? Hi , you cant 'ignore' time as it is an integral part of a datetime variable. The best way to set the time to midnight today would be SELECT DATEDIFF(DAY,0,GetDate()) Dave harshad wrote: > Dear All, > > I want to compare a date with a getDate() > > the problem is that the getDate() returns the time too... > hence 1/1/2004 >= 1/1/2004 13:21 is false... > hence 1/1/2004 >= 1/1/2004 is true... > > i want to ignore the time aspect. Is there any parameters you can send to > getdate() to specify return of just the date? > > Thanks > > harshad prajapati > > > |
|
#3
08-28-2008, 06:08 AM
|
| Re: i want to ignore the time aspect. Is there any parameters you can send to getdate() to specify return of just the date? http://www.karaszi.com/SQLServer/inf....asp#Searching -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "harshad" > Dear All, > > I want to compare a date with a getDate() > > the problem is that the getDate() returns the time too... > hence 1/1/2004 >= 1/1/2004 13:21 is false... > hence 1/1/2004 >= 1/1/2004 is true... > > i want to ignore the time aspect. Is there any parameters you can send to > getdate() to specify return of just the date? > > Thanks > > harshad prajapati > > > |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
All times are GMT -4. The time now is 09:08 PM.
