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 |
|
vini
Starting Member
11 Posts |
 Posted - 2006-11-24 : 04:05:54
|
| I was wondering if it was possible to convert a datetime field lets say getdate() to hhmm.Thanks in advance,Vini |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-11-24 : 04:08:47
|
| Yes. It is possible. But where do you want to show data? If you use front end application, you can use format function thereMadhivananFailing to plan is Planning to fail |
 |
|
|
vini
Starting Member
11 Posts |
Posted - 2006-11-24 : 04:17:04
|
| I am making DTS packages and exporting to a text file,Thx,Vini |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-11-24 : 04:24:23
|
| in sql server help file, read about convert functionMadhivananFailing to plan is Planning to fail |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-24 : 04:25:19
|
| SELECT REPLACE(CONVERT(varchar(5), GETDATE(), 108), ':', '')Peter LarssonHelsingborg, Sweden |
|
|
|
vini
Starting Member
11 Posts |
Posted - 2006-11-24 : 04:33:38
|
| That workedThx a lot! |
|
|
|
|
|
|
Convert datetime to hhmm