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-12-05 : 08:47:35
|
| imran writes "Hi, I use asp pages to run reports, the reports are time driven, so the user selects a date and time frame from drop down boxes and i join them together to form a datetime, pass it to a sql query and it works, but if i try passing it to a stored procedure, it does not read it as a datetime format but as a string, any way i can format a string to datetime???" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2001-12-05 : 09:00:58
|
| Sure, the CONVERT() function is perfect for this. You need to look in Books Online for the details, as it can handle several different datetime formats. |
 |
|
|
|
|
|
DATE format