Sql query to insert datetime in SQL Server

You will want to use the YYYYMMDD for unambiguous date determination in SQL Server.

insert into table1(approvaldate)values('20120618 10:34:09 AM');

If you are married to the dd-mm-yy hh:mm:ss xm format, you will need to use CONVERT with the specific style.

insert into table1 (approvaldate)
       values (convert(datetime,'18-06-12 10:34:09 PM',5));

5 here is the style for Italian dates. Well, not just Italians, but that’s the culture it’s attributed to in Books Online.

Related Posts:

  1. SQL query to select dates between two dates
  2. Rename column SQL Server 2008
  3. Efficiently convert rows to columns in sql server
  4. T-SQL split string based on delimiter
  5. Conversion of a varchar data type to a datetime data type resulted in an out-of-range value in SQL query
  6. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  7. Get day of week in SQL Server 2005/2008
  8. How can I truncate a datetime in SQL Server?
  9. SQL Server WITH statement
  10. DateTime2 vs DateTime in SQL Server
  11. Conversion of a varchar data type to a datetime data type resulted in an out-of-range value in SQL query
  12. SQL Server Insert if not exists
  13. SQL Server: Invalid Column Name
  14. How do I do multiple CASE WHEN conditions using SQL Server 2008?
  15. How do I query for all dates greater than a certain date in SQL Server?
  16. How to insert date values into table
  17. Arithmetic overflow error converting numeric to data type numeric
  18. Determine ROW that caused “unexpected end of file” error in BULK INSERT?
  19. Determine ROW that caused “unexpected end of file” error in BULK INSERT?
  20. Microsoft OLE DB Provider for SQL Server error ‘80004005’
  21. Bulk load data conversion error (truncation)
  22. Convert timestamp to date in Oracle SQL
  23. Query to convert from datetime to date mysql
  24. Subtract one day from datetime
  25. Get current year in TSQL
  26. Can I use multiple “with”?
  27. How do I query for all dates greater than a certain date in SQL Server?
  28. Backup a single table with its data from a database in sql server 2008
  29. How can I group by date time column without taking time into consideration
  30. Arithmetic overflow error converting varchar to data type numeric. ’10’ <= 9.00
  31. Filter data based on date in sql
  32. Varchar invalid for Sum operator
  33. What is a stored procedure?
  34. Unknown column in ‘field list’ error on MySQL Update query
  35. SQL Inner-join with 3 tables?
  36. Conversion failed when converting date and/or time from character string while inserting datetime
  37. MySQL create table if not exists and insert record only if table was created
  38. error, string or binary data would be truncated when trying to insert
  39. ORA-00907: missing right parenthesis
  40. Why do we need “Relationships” between tables at all?
  41. Using group by on multiple columns
  42. SQL Query with NOT LIKE IN
  43. How to declare a variable in MySQL?
  44. ORA-01843 not a valid month- Comparing Dates
  45. How do I escape a single quote in SQL Server?
  46. Teradata: how to convert varchar value (format ‘dd.mm.yyyy’) to date (format ‘yyyy-mm-dd’ )?
  47. How Stuff and ‘For Xml Path’ work in SQL Server?
  48. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  49. Oracle SELECT TOP 10 records
  50. must appear in the GROUP BY clause or be used in an aggregate function
  51. How can I return pivot table output in MySQL?
  52. The multi-part identifier could not be bound
  53. MySQL syntax for Join Update
  54. SQLite – UPSERT *not* INSERT or REPLACE
  55. how to drop partition without dropping data in MySQL?
  56. Simple way to calculate median with MySQL
  57. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
  58. Error 1046 No database Selected, how to resolve?
  59. What is it exactly a BLOB in a DBMS context
  60. Insert text with single quotes in PostgreSQL
  61. SQL Server IF NOT EXISTS Usage?
  62. I want to use CASE statement to update some records in sql server 2005
  63. SELECT DISTINCT on one column
  64. TSQL PIVOT MULTIPLE COLUMNS
  65. MySQL – UPDATE multiple rows with different values in one query
  66. How to create a MySQL hierarchical recursive query?
  67. SQL Parentheses use in an OR clause
  68. Is it possible to GROUP BY multiple columns using MySQL?
  69. Equivalent of Oracle’s RowID in SQL Server
  70. Is there a Max function in SQL Server that takes two values like Math.Max in .NET?
  71. Best way to test if a row exists in a MySQL table
  72. sql query to return differences between two tables
  73. Is it possible to specify condition in Count()?
  74. SQL Server: Make all UPPER case to Proper Case/Title Case
  75. updating table rows in postgres using subquery
  76. Temporary table in SQL server causing ‘ There is already an object named’ error
  77. MySQL OPTIMIZE all tables?
  78. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  79. Is there a coalesce-like function in Excel?
  80. How do I count unique items in field in Access query?
  81. How to select the last record of a table in SQL?
  82. Sqlite: CURRENT_TIMESTAMP is in GMT, not the timezone of the machine
  83. MySQL LIKE IN()?
  84. What is a postgres superuser
  85. ora-06553 pls-306 wrong number or types of arguments in call to ‘ogc_x’
  86. SQL query to extract only the “current” wp_posts?
  87. How to retrieve sticky post in raw sql?
  88. How to remove in the wordpress database all posts revisions except the last three?
  89. Backticks (`) Instead of Single Quotes (‘) in an SQL Statement?
  90. $wpdb get_var issue
  91. WP Optimization: Removing Orphaned wp_options (especially the autoload ones)
  92. Auto-update tables from database
  93. Inserting rows into a custom table, when plugin is activated
  94. dbDelta not creating table (yes, once more)
  95. Posts modified in the last 48 hours
  96. post id not displaying
  97. How to export 2 week’s worth of posts
  98. Insert multiple checkbox values
  99. How to get EVENT based on startday, using BETWEEN
  100. wpdb prepare without placeholder

Leave a Comment