tsql - How to get DateTime formated -
in sql server how can current date time 12:00 am. getdate() current date , time.i need have datetime formated this: 2011-02-04 12:00 or 2011-02-04 00:01 thanks you first need know how time want. called "flooring" date time. see example: --floor datetime select '0 none', getdate() -- none 2008-09-17 12:56:53.430 union select '1 second',dateadd(second,datediff(second,'2000-01-01',getdate()),'2000-01-01') -- second: 2008-09-17 12:56:53.000 union select '2 minute',dateadd(minute,datediff(minute,0,getdate()),0) -- minute: 2008-09-17 12:56:00.000 union select '3 hour', dateadd(hour,datediff(hour,0,getdate()),0) -- hour: 2008-09-17 12:00:00.000 union select '4 day', dateadd(day,datediff(day,0,getdate()),0) -- day: 2008-09-17 00:00:00.000 union select ...