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 |
masond
Constraint Violating Yak Guru
447 Posts |
Posted - 2014-02-27 : 03:47:59
|
Hey guys I have the following field “Period_DT” displayed as “2012-12-01” how can i make it ‘2012-12-01 00:00:00’Column Name : Period_DTDate type : DateLooking forward to your help RegardD |
|
VeeranjaneyuluAnnapureddy
Posting Yak Master
169 Posts |
Posted - 2014-02-27 : 03:55:16
|
SELECT CAST(Period_DT AS DATETIME) AS Period_DTVeera |
|
|
masond
Constraint Violating Yak Guru
447 Posts |
Posted - 2014-02-27 : 04:16:24
|
Thanks VeeranjaneyuluAnnapureddyThats exactly what i wanted :) |
|
|
|
|
|