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 |
|
ackrite55
Starting Member
3 Posts |
 Posted - 2009-09-15 : 21:10:15
|
| I have seen plenty of documentation on how to convert the date format to & from the Hundred Years Format. But nothing regarding the time. For example, 40065: 9/10/2009 -/+ 1 in Sql Server & Excel. However, 2402 doesn't indicate military time. Does anyone have a suggestion? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2009-09-15 : 22:35:50
|
quote:
For example, 40065: 9/10/2009 -/+ 1 in Sql Server & Excel. However, 2402 doesn't indicate military time
Don't quite understand what do you mean here. what is Hundred Years Format ? What does this value 40065 represent ?
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-09-16 : 02:20:25
|
quote:
Originally posted by khtan
quote:
For example, 40065: 9/10/2009 -/+ 1 in Sql Server & Excel. However, 2402 doesn't indicate military time
Don't quite understand what do you mean here. what is Hundred Years Format ? What does this value 40065 represent ?
KH[spoiler]Time is always against us[/spoiler]
select dateadd(day,40065,0)MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Hundred Year Format Conversion