/SQL/SQL Server date literal

SQL Server date literal

SQL Server date literal

--DateTime
SELECT {ts'2015-09-20 12:30:00'}
--Time (however this comes with "today"-time)
SELECT {t'12:30:00'}
--Date
SELECT {d'2015-09-20'}
GO

0

Source: stackoverflow.com

Similar codes

0 vote195 views1 answer
How to output a different column name in mysql
SQL
0 vote197 views1 answer
Kotlin sqlite delete row
SQL
0 vote234 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
11 votes583 views4 answers
Reset identity column values in sql server
SQL
0 vote218 views1 answer
Postgres populate table from another table
SQL
-1 vote216 views1 answer
Extract Data from SQL Server into XML Format
SQL
19 votes221 views5 answers
Date between in mysql
SQL
0 vote199 views1 answer
Minecraft duping allowed servers
SQL
16 votes210 views2 answers
Add column if not exists mysql
SQL
0 vote197 views1 answer
Mysql command prompt date insert format
SQL

Share