SQL Custom Parameter

[guest2013-1]

I prefer my method, it's easy to read into a database and extract out of a database. Any human and/or PC can understand

 

[FarligOpptreden]

I prefer my method, it's easy to read into a database and extract out of a database. Any human and/or PC can understand

I prefer the [big announcer type voice]ISO STANDARD[/big announcer type voice] of yyyyMMdd.

 

[TelkomUseless]

No no no! Not yyyy/MM/dd, but yyyyMMdd (without the "/"). All our date formats were in yyyy/MM/dd and we had loads of trouble. Since removing the "/"-es and just formatting it as yyyyMMdd we haven't had any problems... YET.

EDIT: Here's an interesting article about it:

http://www.sql-server-performance.com/articles/dev/datetime_datatype_p1.aspx

I have used the '/' with zero issues in the past. I checked the BOL and some sources.. but I see they the ISO standard is withouth '/'.

But many ways to skin a cat

 

[guest2013-1]

I prefer the [big announcer type voice]ISO STANDARD[/big announcer type voice] of yyyyMMdd.

**** ISO standards dude, I haven't had a date headache since 1998 with this ****...

 

[dequadin]

Woohoo! Seems like you just passed an ominous post count...

Indeed that was a while ago

I prefer the [big announcer type voice]ISO STANDARD[/big announcer type voice] of yyyyMMdd.

/me Puts aways the standards stick (for now...)

 

[FarligOpptreden]

Indeed that was a while ago

Your post-count was 667 when I posted that reply, so becoming a "Master" was not what I referred to...

/me Puts aways the standards stick (for now...)

/me keeps an eye on dequadin's hand, just in case...

 

[TelkomUseless]

First we had the grammar police..

now

Standards police...