Skip to content

Instantly share code, notes, and snippets.

@InvaderZim85

InvaderZim85/Tsql_SmallDateTimeVSDateTime.txt

Created April 9, 2021 11:04
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save InvaderZim85/97b6f214b24e865844a0eef68bb75466 to your computer and use it in GitHub Desktop.
Save InvaderZim85/97b6f214b24e865844a0eef68bb75466 to your computer and use it in GitHub Desktop.
Download ZIP
TSQL - SMALLDATETIME vs. DATETIME
Raw
Tsql_SmallDateTimeVSDateTime.txt
+---------------------+---------------------+---------------------+
| Test-Wert | SMALLDATETIME | DATETIME |
+---------------------+---------------------+---------------------+
| 09.04.2021 23:59:00 | 09/04/2021 23:59:00 | 09/04/2021 23:59:00 |
| 09.04.2021 23:59:01 | 09/04/2021 23:59:00 | 09/04/2021 23:59:01 |
| 09.04.2021 23:59:02 | 09/04/2021 23:59:00 | 09/04/2021 23:59:02 |
| 09.04.2021 23:59:03 | 09/04/2021 23:59:00 | 09/04/2021 23:59:03 |
| 09.04.2021 23:59:04 | 09/04/2021 23:59:00 | 09/04/2021 23:59:04 |
| 09.04.2021 23:59:05 | 09/04/2021 23:59:00 | 09/04/2021 23:59:05 |
| 09.04.2021 23:59:06 | 09/04/2021 23:59:00 | 09/04/2021 23:59:06 |
| 09.04.2021 23:59:07 | 09/04/2021 23:59:00 | 09/04/2021 23:59:07 |
| 09.04.2021 23:59:08 | 09/04/2021 23:59:00 | 09/04/2021 23:59:08 |
| 09.04.2021 23:59:09 | 09/04/2021 23:59:00 | 09/04/2021 23:59:09 |
| 09.04.2021 23:59:10 | 09/04/2021 23:59:00 | 09/04/2021 23:59:10 |
| 09.04.2021 23:59:11 | 09/04/2021 23:59:00 | 09/04/2021 23:59:11 |
| 09.04.2021 23:59:12 | 09/04/2021 23:59:00 | 09/04/2021 23:59:12 |
| 09.04.2021 23:59:13 | 09/04/2021 23:59:00 | 09/04/2021 23:59:13 |
| 09.04.2021 23:59:14 | 09/04/2021 23:59:00 | 09/04/2021 23:59:14 |
| 09.04.2021 23:59:15 | 09/04/2021 23:59:00 | 09/04/2021 23:59:15 |
| 09.04.2021 23:59:16 | 09/04/2021 23:59:00 | 09/04/2021 23:59:16 |
| 09.04.2021 23:59:17 | 09/04/2021 23:59:00 | 09/04/2021 23:59:17 |
| 09.04.2021 23:59:18 | 09/04/2021 23:59:00 | 09/04/2021 23:59:18 |
| 09.04.2021 23:59:19 | 09/04/2021 23:59:00 | 09/04/2021 23:59:19 |
| 09.04.2021 23:59:20 | 09/04/2021 23:59:00 | 09/04/2021 23:59:20 |
| 09.04.2021 23:59:21 | 09/04/2021 23:59:00 | 09/04/2021 23:59:21 |
| 09.04.2021 23:59:22 | 09/04/2021 23:59:00 | 09/04/2021 23:59:22 |
| 09.04.2021 23:59:23 | 09/04/2021 23:59:00 | 09/04/2021 23:59:23 |
| 09.04.2021 23:59:24 | 09/04/2021 23:59:00 | 09/04/2021 23:59:24 |
| 09.04.2021 23:59:25 | 09/04/2021 23:59:00 | 09/04/2021 23:59:25 |
| 09.04.2021 23:59:26 | 09/04/2021 23:59:00 | 09/04/2021 23:59:26 |
| 09.04.2021 23:59:27 | 09/04/2021 23:59:00 | 09/04/2021 23:59:27 |
| 09.04.2021 23:59:28 | 09/04/2021 23:59:00 | 09/04/2021 23:59:28 |
| 09.04.2021 23:59:29 | 09/04/2021 23:59:00 | 09/04/2021 23:59:29 |
| 09.04.2021 23:59:30 | 10/04/2021 00:00:00 | 09/04/2021 23:59:30 |
| 09.04.2021 23:59:31 | 10/04/2021 00:00:00 | 09/04/2021 23:59:31 |
| 09.04.2021 23:59:32 | 10/04/2021 00:00:00 | 09/04/2021 23:59:32 |
| 09.04.2021 23:59:33 | 10/04/2021 00:00:00 | 09/04/2021 23:59:33 |
| 09.04.2021 23:59:34 | 10/04/2021 00:00:00 | 09/04/2021 23:59:34 |
| 09.04.2021 23:59:35 | 10/04/2021 00:00:00 | 09/04/2021 23:59:35 |
| 09.04.2021 23:59:36 | 10/04/2021 00:00:00 | 09/04/2021 23:59:36 |
| 09.04.2021 23:59:37 | 10/04/2021 00:00:00 | 09/04/2021 23:59:37 |
| 09.04.2021 23:59:38 | 10/04/2021 00:00:00 | 09/04/2021 23:59:38 |
| 09.04.2021 23:59:39 | 10/04/2021 00:00:00 | 09/04/2021 23:59:39 |
| 09.04.2021 23:59:40 | 10/04/2021 00:00:00 | 09/04/2021 23:59:40 |
| 09.04.2021 23:59:41 | 10/04/2021 00:00:00 | 09/04/2021 23:59:41 |
| 09.04.2021 23:59:42 | 10/04/2021 00:00:00 | 09/04/2021 23:59:42 |
| 09.04.2021 23:59:43 | 10/04/2021 00:00:00 | 09/04/2021 23:59:43 |
| 09.04.2021 23:59:44 | 10/04/2021 00:00:00 | 09/04/2021 23:59:44 |
| 09.04.2021 23:59:45 | 10/04/2021 00:00:00 | 09/04/2021 23:59:45 |
| 09.04.2021 23:59:46 | 10/04/2021 00:00:00 | 09/04/2021 23:59:46 |
| 09.04.2021 23:59:47 | 10/04/2021 00:00:00 | 09/04/2021 23:59:47 |
| 09.04.2021 23:59:48 | 10/04/2021 00:00:00 | 09/04/2021 23:59:48 |
| 09.04.2021 23:59:49 | 10/04/2021 00:00:00 | 09/04/2021 23:59:49 |
| 09.04.2021 23:59:50 | 10/04/2021 00:00:00 | 09/04/2021 23:59:50 |
| 09.04.2021 23:59:51 | 10/04/2021 00:00:00 | 09/04/2021 23:59:51 |
| 09.04.2021 23:59:52 | 10/04/2021 00:00:00 | 09/04/2021 23:59:52 |
| 09.04.2021 23:59:53 | 10/04/2021 00:00:00 | 09/04/2021 23:59:53 |
| 09.04.2021 23:59:54 | 10/04/2021 00:00:00 | 09/04/2021 23:59:54 |
| 09.04.2021 23:59:55 | 10/04/2021 00:00:00 | 09/04/2021 23:59:55 |
| 09.04.2021 23:59:56 | 10/04/2021 00:00:00 | 09/04/2021 23:59:56 |
| 09.04.2021 23:59:57 | 10/04/2021 00:00:00 | 09/04/2021 23:59:57 |
| 09.04.2021 23:59:58 | 10/04/2021 00:00:00 | 09/04/2021 23:59:58 |
| 09.04.2021 23:59:59 | 10/04/2021 00:00:00 | 09/04/2021 23:59:59 |
+---------------------+---------------------+---------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment