Sql

declare @X datetime
set @X = '2012-01-25 17:24:05.784'
select convert(datetime, convert(char(19), @X, 126))

select dateadd(millisecond, -datepart(millisecond, @X), @X)

PREVIOUS	NEXT

Code Example
Sql :: cast find duration in sql
Sql :: jpa generationtype sequence mysql
Sql :: dbms transaction tutorialspoint
Sql :: mysql max number not returning correct value
Sql :: convert mongodb to sql
Sql :: salesforce cpq apply immediately
Sql :: how to check if sql query is correct online
Sql :: homebrew/sqlitestudio
Sql :: dbname+tablename
Sql :: oracle query to find schema you are working on
Sql :: sql filter rows with condition
Sql :: count in spqarql
Sql :: ring close the connection to the database using the odbc_disconnect()
Sql :: postgresql get tables where column is foreign key
Sql :: sql interview questions
Sql :: sql truncate number
Sql :: union and union all
Sql :: how to create foreign key in sql server management studio
Sql :: oracle sql first day of quarter
Sql :: row over partition in sql
Sql :: xamarin sql lite create table if not exist
Sql :: sql statement show all emails with dome
Csharp :: unity if in editor
Csharp :: regions unity
Csharp :: loop through an enum c#
Csharp :: how to stop window from terminating c# visual studio
Csharp :: how to change image color unity
Csharp :: get unix time in seconds C#
Csharp :: pause audio unity
Csharp :: current directory in sln file c#