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 |
|
tigerweld
Starting Member
12 Posts |
 Posted - 2011-05-26 : 14:19:49
|
| When I run my query my TimeTransmitted is coming out like:5/25/2011 1:13:06 PMAll I want is the date in this format2011-05-25What is the proper syntax?SELECT Client_db.dbo.Deposits.DDA, Client_db.dbo.Deposits.SiteID,Client_db.dbo.Deposits.TimeTransmitted,Client_db.dbo.MICR.CheckNumber,Client_db.dbo.MICR.AmountFROM Client_db.dbo.DepositsINNER JOIN Client_db.dbo.MICRON Client_db.dbo.MICR.DepositID = Client_db.dbo.Deposits.DepositIDWHERE Client_db.dbo.Deposits.CustomerID = '132' |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-05-26 : 14:25:48
|
| convert(date,Deposits.TimeTransmitted)convert(var(8),Deposits.TimeTransmitted,121)==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2011-05-26 : 14:28:00
|
| If that's the way your data is looks in the database, it isn't a date data typeselect convert(varchar(10),convert(datetime,'5/25/2011 1:13:06 PM'),121)JimEveryday I learn something that somebody else already knew |
|
|
|
tigerweld
Starting Member
12 Posts |
Posted - 2011-05-26 : 14:44:53
|
| when I use the convert it's telling me Type var is not a defined system type.Does the same for date. |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-05-26 : 15:26:37
|
| sorryconvert(varchar(8),Deposits.TimeTransmitted,121)==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
tigerweld
Starting Member
12 Posts |
Posted - 2011-05-26 : 17:15:44
|
| Beautiful! Thanks man. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2011-05-30 : 06:37:03
|
| If you want to show data in the front end application, do the formation thereMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
|
|
format Date