Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and beauty - How to insert date-time format data into sqlserver
How to insert date-time format data into sqlserver
You can insert the character form of a short date or a long date.

1, create a test table:

Create? Table? test

(ttime? Date and time); 2. Insert a short date:

Insert? Become? Testing? Values? ('20 15-09- 14'); Screenshot of results:

3. Insert long date:

Insert? Become? Testing? Values? ('20 15-09- 14? 23:59:59') Screenshot of the result: