Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««12345

T-SQL Expand / Collapse
Author
Message
Posted Sunday, January 02, 2011 11:37 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, March 11, 2011 11:22 PM
Points: 19, Visits: 36
Nice question, didn't have any idea about cut off year.
Post #1041644
Posted Friday, April 22, 2011 10:18 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Sunday, March 04, 2012 4:02 AM
Points: 660, Visits: 134
I was kind off expecting SQL to throw an error due to regional settings. I am in South Africa and we specify the day before the month (the day is after all smaller than the month).

Are there any regional settings when this won't work?

It did throw a fault when I ran:

SELECT CAST('22/02/00' AS DATETIME)

which would be 'dd/mm/yy'.

Good question but SQL would throw an error it wasn't 02 February all the time.
Post #1097516
« Prev Topic | Next Topic »

Add to briefcase «««12345

Permissions Expand / Collapse