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 |
|
themoney32
Starting Member
20 Posts |
 Posted - 2009-09-22 : 00:29:51
|
| I have a query that is working correctly but I am struggling to add in one thing. I have to show the identifiers for late shipments and the number of days they were late. I use this query and it works...SELECT OrderID, CustomerID, EmployeeID, DATEDIFF(ShippedDate, OrderDate) as DaysLate FROM orders o WHERE DATEDIFF(ShippedDate, OrderDate) > 7 However, I also need to show the dates from my fields of OrderDate, RequiredDate, ShippedDate, in the format as this example, "Jan 23, 1998". I know I am suppose to use DATE_FORMAT but I cannot seem to get it to work, any thoughts? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-09-22 : 01:55:35
|
DATE_FORMAT is MySQL, this is a forum for MSSQL.Do you want a solution for MSSQL?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-09-22 : 02:54:35
|
| Post your question at www.mysql.comMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
|
|
DATE_FORMAT