What do you want to save?
Add Code snippet
New code examples
-
SQL 2022-03-12 07:25:04
REMOVE DATE FROM DATE TIME SQL SERVER
First thing's first, if your dates are in varchar format change that, store dates as dates it will save you a lot of headaches and it is something that is best done sooner rather than later. The problem will only get worse. Secondly, once you have a date... Add solution
Best helpers
Simon LANG
+5
Ryo Hirai
+5
Rio1210
+5
Sqlsourcerer
+5
Pierus
+5
Ken N.
+5
Rene Duchamp
+5
Peanutjelly
+5
Susette87
+5
Tanveer Ali
+5
NeoNosliw
+5
Derek Kaplan
+5
Littleprince
+5
Bridget W.
+5
Haidy Kassem
+5
Ferhat Turan
+5
Jwp36
+5
Andrew Besag
+5