Formatting Dates - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Formatting Dates

Author

Topic

oahu9872
Posting Yak Master

112 Posts

Posted - 2008-11-07 : 10:41:09

Hello,

I want to do a query for transactions in the month of October. If I want to give a field called dateCreated a range of >= October 1st and <= October 31st in the WHERE clause, how do I properly format the dates?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-07 : 10:43:40

WHERE datefield >= '1 Oct 2008'
AND datefield< '1 Nov 2008'

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-11-10 : 02:20:27

or

WHERE datefield >= '20081001'
AND datefield< '20081101'

Madhivanan

Failing to plan is Planning to fail

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-10 : 02:37:51

quote:
Originally posted by madhivanan

or

WHERE datefield >= '20081001'
AND datefield< '20081101'

Madhivanan

Failing to plan is Planning to fail

I prefer the former way as it has better clarity

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-11-10 : 02:57:55

quote:
Originally posted by visakh16

quote:
Originally posted by madhivanan

or

WHERE datefield >= '20081001'
AND datefield< '20081101'

Madhivanan

Failing to plan is Planning to fail

I prefer the former way as it has better clarity

It wont work in non-English Servers

Madhivanan

Failing to plan is Planning to fail

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-10 : 02:59:48

It wont work in non-English Servers

Madhivanan

Failing to plan is Planning to fail
[/quote]
Ok...But i work in English servers

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-11-10 : 03:04:04

quote:
quote:
Originally posted by visakh16

It wont work in non-English Servers

Madhivanan

Failing to plan is Planning to fail

Ok...But i work in English servers

We may not know if OP works in English servers

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources