3> 4> SELECT CONVERT(datetime, CONVERT( varchar(11), '2005-08-13 20:37:22.570', 101)) 5> GO ----------------------- 2005-08-13 00:00:00.000 (1 rows affected)
5.9.datetime | ||||
5.9.1. | datetime type | |||
5.9.2. | Store the date and time for a change in a datetime format. | |||
5.9.3. | Billings on or before a specified date | |||
5.9.4. | A BETWEEN phrase with literal values | |||
5.9.5. | Using comperison operator with Date value | |||
5.9.6. | Between date | |||
5.9.7. | SET start_Date = GETDATE() | |||
5.9.8. | Use 'LIKE pattern' match with a date type value | |||
5.9.9. | An UPDATE statement that assigns new values to datetime column with string value | |||
5.9.10. | CAST(OrderDate AS varchar) | |||
5.9.11. | Specify date with string (OrderDate = '7/4/1996') | |||
5.9.12. | Performing Date Conversions | |||
5.9.13. | SELECT CONVERT(datetime, CONVERT( varchar(11), '2005-08-13 20:37:22.570', 101)) | |||
5.9.14. | Add integer and float number to a date value | |||
5.9.15. | A SELECT statement that ignores date values | |||
5.9.16. | A SELECT statement that uses the CONVERT function to remove time values | |||
5.9.17. | A SELECT statement that uses the CAST function to remove time values | |||
5.9.18. | A SELECT statement that searches for month, day, and year components |