Sql

--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

PREVIOUS	NEXT

Code Example
Sql :: take sql dump in to file
Sql :: Create parameterized VIEW in SQL Server
Sql :: oracle sql get value from several rows and concatenate strings
Sql :: mysql workbench change default value
Sql :: sql average
Sql :: copy data from one database to another
Sql :: create procedure
Sql :: mysql workbench view
Sql :: example database query
Sql :: Triggers Syntax
Sql :: copy table db
Sql :: substract variable amount of minutes from timestamp postgresql
Sql :: mysql select random rows large table
Sql :: windows could not start the sql server on local computer
Sql :: alter table name including schema
Sql :: how to use join with 3 tables in sql server
Sql :: was not locked with LOCK TABLES
Sql :: sql injection
Sql :: soql last year
Sql :: how to insert multiple rows in mysql using laravel
Sql :: mysql workbench primary key
Sql :: Power BI merge tables same columns
Sql :: sql selet
Sql :: C# mysql update statement set value to null
Sql :: duplicate a column in sql
Sql :: if mysql UPDATE
Sql :: query to generate query to drop primary keys or foreign key in ms sql server
Sql :: how to select only first 3 characters in sql
Sql :: sql tablo hangi sp de
Sql :: how to update date in oracle