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 |
|
jimrose
Starting Member
2 Posts |
 Posted - 2009-04-29 : 14:45:14
|
| I am writing a query and in the Birthdate field, I want to reformat it so as to return six characters in the form of mmddyy. I have done this many times before but for some reason, this time, I am getting an error message saying that I have a syntax error because of a mis-use of the comma. Here is the way I am writing the format change:Expr 1: Format ([flddBirthDate], "mmddyy")Any body see a mistake in this? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-07 : 01:59:29
|
Use semicolon ";" instead.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
jimrose
Starting Member
2 Posts |
Posted - 2009-05-11 : 17:51:53
|
| Tried it but the error message says I used an invalid character. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-05-12 : 01:43:44
|
| Post the full code you usedMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
format the date