201047/sql-query-to-insert-datetime-in-sql-server
Using the SQL query below, I want to add a datetime value to a table (SQL Server).
insert into table1(approvaldate)values(18-06-12 10:34:09 AM);
But I get this Error msg:
Incorrect syntax near '10'.
Can someone please help me with this?
I am aware that the Group Concat ...READ MORE
I tried to build a table from ...READ MORE
To modify the format of a date ...READ MORE
Try to check for existence: IF NOT EXISTS ...READ MORE
In SQL Server 2012 and up you ...READ MORE
You are getting the joins confused and ...READ MORE
I require the minutes-based time difference between ...READ MORE
I only need to choose the given ...READ MORE
SELECT GETDATE() Returns: 2008-09-22 15:24:13.790 I want that date part ...READ MORE
To obtain the year from the given ...READ MORE
OR
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.