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 Gopi Sri » T-SQL

42 posts, Page 5 of 5

«««1 2 3 4 5

T-SQL

Rate Topic

Display Mode

Topic Options

Author

Message

payal vyas

Posted Sunday, January 02, 2011 11:37 AM

Grasshopper

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

terrykzncs

Posted Friday, April 22, 2011 10:18 AM

SSChasing 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 »

42 posts, Page 5 of 5

«««1 2 3 4 5

Permissions