T-SQL

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Carlo Romagnano » T-SQL

53 posts, Page 6 of 6

«««2 3 4 5 6

T-SQL

Rate Topic

Display Mode

Topic Options

Author

Message

dennisp

Posted Friday, March 06, 2009 12:32 PM

SSC-Addicted

Group: General Forum Members
Last Login: Thursday, April 25, 2013 3:06 PM
Points: 432, Visits: 102

as mentioned in a prior comment, the answer to the question is wrong!!
Try runing this and you'll see a 2/1/09 value....

create table #a (InsertedOn datetime)
insert into #a values ('20090131');
insert into #a values ('01/31/09 23:59:59.999');
insert into #a values ('01/31/09 12:59:59.999');
insert into #a values ('20090131');
insert into #a values ('20090131');
SELECT [InsertedOn] FROM #a WHERE [InsertedOn] BETWEEN '20090131' AND '20090131 23:59:59.999'
drop table #a

Dennis Parks
MCSE, MCDBA, MCSD, MCAD, MCTS

Post #670577

diaz.bernabe

Posted Monday, November 02, 2009 9:53 PM

Old Hand

Group: General Forum Members
Last Login: Friday, May 10, 2013 8:48 AM
Points: 313, Visits: 165

in the question never showed an implicit date time conversion, therefore you can not require that condition as granted.
Your question is bad formulated or you are trying to trick (fool) people.

Post #812720

diaz.bernabe

Posted Monday, November 02, 2009 9:56 PM

Old Hand

Group: General Forum Members
Last Login: Friday, May 10, 2013 8:48 AM
Points: 313, Visits: 165

in the question never showed an implicit date time conversion, therefore you can not require that condition as granted.
Your question is bad formulated or you are trying to trick (fool) people.

Post #812721

« Prev Topic | Next Topic »

53 posts, Page 6 of 6

«««2 3 4 5 6

Permissions