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 |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2007-01-11 : 04:53:36
|
| i have a datetime fieldis there a way to select it to come up in the format of ddmmyyyy (where is the day is 3 it will put 03) is there an automatic function for this? |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2007-01-11 : 04:58:05
|
select replace(convert(varchar, getdate() - 4, 103), '/', '')Duane.  |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2007-01-11 : 05:36:16
|
| thanks just what i needed :) |
|
|
|
|
|
|
select datetime