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 |
|
Delinda
Constraint Violating Yak Guru
315 Posts |
 Posted - 2010-07-18 : 03:58:42
|
| In my table, My Last Maintenance Date as follow,LstMaintDte---------------------------7/17/2010 7:45:12 AMHow my sql looks like, to show LstMaintDte as follow17.07.10 7:45AM |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-07-18 : 04:07:23
|
Look up "CAST & CONVERT" in Books Online, the SQL Server help file.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-07-18 : 06:30:50
|
| what is the type of column where you have this LstMaintDte Stored? |
|
|
|
Delinda
Constraint Violating Yak Guru
315 Posts |
Posted - 2010-07-18 : 07:55:13
|
| my LstMaintDte is DateTime |
|
|
|
|
|
|
Need help on SQL