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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-04 : 19:47:45
|
| Ray writes "We have many different DataBase's here and in some of them the dates are stored as char and others it is datetime datatype (Hey, I didn't build them). My big question is how do I add hours, minutes, and days to either type. I know that the days can be added to the getdate function or the datetime datatypes by just adding an integer. But what about hours and minutes? With the char types, I had to write a cursor(after many hours of trial and error). And if they put in anything over 24 hours or 60 minutes, gets an overflow error. We are using MSSQL 7 on Windows 2000 boxes if that will help. I haven't worked on MSSQL before but Sybase in the past (But not any date changes). Any info or book references will be of great help." |
|
|
|
|
|
getdate functionality