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.
| Author |
Topic |
|
pithhelmet
Posting Yak Master
183 Posts |
 Posted - 2002-12-22 : 16:53:11
|
| Hi All -I am trying to do a data conversion - and i'm running into this problem.....select convert(datetime, '14-Apr-40', 101)returns2040-04-14 00:00:00.000Where do i set the low year epoc???thankstonyEdited by - pithhelmet on 12/22/2002 16:55:17 |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-12-22 : 17:26:45
|
| look in BOL undertwo digit year cutoff Optionorsp_configureyou can set it in enterprise manageror use sp_configureThe default time span is 1950-2049.Edited by - ValterBorges on 12/22/2002 17:30:47 |
 |
|
|
|
|
|
date conversion....