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 |
|
shemayb
Posting Yak Master
159 Posts |
 Posted - 2008-02-21 : 21:54:10
|
| i can't find the format style for mmddyyyy..Funnyfrog |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-21 : 22:21:06
|
| You can get that like:select replace(convert(char(10), getdate(), 101), '/', '') |
 |
|
|
shemayb
Posting Yak Master
159 Posts |
Posted - 2008-02-21 : 22:29:29
|
| Thank you so much!Funnyfrog |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-02-22 : 01:00:37
|
quote:
Originally posted by shemayb
i can't find the format style for mmddyyyy..Funnyfrog
If your destination is front end then you can find it Format(datecol,"mmddyyyy")MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
format style