http://www.thewayithink.co.uk/ thebeebs - How to Floor an SQL DateTime 2008-08-13T04:37:31+00:00 Zeroing the desk - Ignore the design My name BlogEngine.Net Syndication Generator http://www.thewayithink.co.uk/opml.axd http://www.dotnetblogengine.net/syndication.axd My name Zeroing the desk - Ignore the design en-US thebeebs 0.000000 0.000000 http://www.thewayithink.co.uk/post/2008/07/03/How-to-Floor-an-SQL-datatime.aspx#id_f380acd1-ee37-4d4e-aec6-f365900fef07 Tomislav on <a href="/post/2008/07/03/How-to-Floor-an-SQL-datatime.aspx#id_f380acd1-ee37-4d4e-aec6-f365900fef07" alt="/post/2008/07/03/How-to-Floor-an-SQL-datatime.aspx#id_f380acd1-ee37-4d4e-aec6-f365900fef07">How to Floor an SQL DateTime</a> 2008-08-13T04:37:31+00:00 Tomislav select cast(convert(varchar,getdate(),106) as datetime) 2008-08-13T04:37:31+00:00 Tomislav http://www.thewayithink.co.uk/pingback.axd http://www.thewayithink.co.uk/post/2008/07/03/How-to-Floor-an-SQL-datatime.aspx#id_f380acd1-ee37-4d4e-aec6-f365900fef07 http://www.thewayithink.co.uk/post/2008/07/03/How-to-Floor-an-SQL-datatime.aspx#id_f380acd1-ee37-4d4e-aec6-f365900fef07#comment http://www.thewayithink.co.uk/syndication.axd?post=f380acd1-ee37-4d4e-aec6-f365900fef07 http://www.thewayithink.co.uk/post/2008/07/03/How-to-Floor-an-SQL-datatime.aspx#id_dc4e179e-dafa-424e-b99e-10712fcb576c nishant on <a href="/post/2008/07/03/How-to-Floor-an-SQL-datatime.aspx#id_dc4e179e-dafa-424e-b99e-10712fcb576c" alt="/post/2008/07/03/How-to-Floor-an-SQL-datatime.aspx#id_dc4e179e-dafa-424e-b99e-10712fcb576c">How to Floor an SQL DateTime</a> 2009-02-11T22:01:19+00:00 nishant insted of this you can use select convert(datetime,convert(int, getdate())) as date it is more easy 2009-02-11T22:01:19+00:00 nishant http://www.thewayithink.co.uk/pingback.axd http://www.thewayithink.co.uk/post/2008/07/03/How-to-Floor-an-SQL-datatime.aspx#id_dc4e179e-dafa-424e-b99e-10712fcb576c http://www.thewayithink.co.uk/post/2008/07/03/How-to-Floor-an-SQL-datatime.aspx#id_dc4e179e-dafa-424e-b99e-10712fcb576c#comment http://www.thewayithink.co.uk/syndication.axd?post=dc4e179e-dafa-424e-b99e-10712fcb576c http://www.thewayithink.co.uk/post/2008/07/03/How-to-Floor-an-SQL-datatime.aspx#id_2999f0ae-cfad-472c-87b7-0ad00bb2118c <a class="comment_auth" href="http://www.thewayithink.co.uk/" alt="http://www.thewayithink.co.uk/" title="http://www.thewayithink.co.uk/">thebeebs</a> on <a href="/post/2008/07/03/How-to-Floor-an-SQL-datatime.aspx#id_2999f0ae-cfad-472c-87b7-0ad00bb2118c" alt="/post/2008/07/03/How-to-Floor-an-SQL-datatime.aspx#id_2999f0ae-cfad-472c-87b7-0ad00bb2118c">How to Floor an SQL DateTime</a> 2009-02-12T04:20:19+00:00 thebeebs @nishant, That won't work, if you run it with a date with a time past 12:00 then it will add a day on to the result date: <strong>Morining Test:</strong> DECLARE @Testdate datetime SET @Testdate = convert(datetime, '03/June/1982 00:00:00') Select @Testdate select convert(datetime,convert(int, @Testdate)) as date RESULT 1: 1982-06-03 00:00:00.000 RESULT 2: 1982-06-03 00:00:00.000 <strong>Afternoon Test:</strong> DECLARE @Testdate datetime SET @Testdate = convert(datetime, '03/June/1982 13:00:00') Select @Testdate select convert(datetime,convert(int, @Testdate)) as date RESULT 1: 1982-06-03 13:00:00.000 RESULT 2: 1982-06-04 00:00:00.000 2009-02-12T04:20:19+00:00 thebeebs http://www.thewayithink.co.uk/pingback.axd http://www.thewayithink.co.uk/post/2008/07/03/How-to-Floor-an-SQL-datatime.aspx#id_2999f0ae-cfad-472c-87b7-0ad00bb2118c http://www.thewayithink.co.uk/post/2008/07/03/How-to-Floor-an-SQL-datatime.aspx#id_2999f0ae-cfad-472c-87b7-0ad00bb2118c#comment http://www.thewayithink.co.uk/syndication.axd?post=2999f0ae-cfad-472c-87b7-0ad00bb2118c http://www.thewayithink.co.uk/post/2008/07/03/How-to-Floor-an-SQL-datatime.aspx#id_16d7e226-1554-44e4-8b9e-0dec2d90ceaf nishant on <a href="/post/2008/07/03/How-to-Floor-an-SQL-datatime.aspx#id_16d7e226-1554-44e4-8b9e-0dec2d90ceaf" alt="/post/2008/07/03/How-to-Floor-an-SQL-datatime.aspx#id_16d7e226-1554-44e4-8b9e-0dec2d90ceaf">How to Floor an SQL DateTime</a> 2009-02-12T04:42:43+00:00 nishant Thank a lot <img src="/editors/tiny_mce_3_3_9_2/plugins/emotions/img/smiley-smile.gif" class="flag" alt="Smile" /> 2009-02-12T04:42:43+00:00 nishant http://www.thewayithink.co.uk/pingback.axd http://www.thewayithink.co.uk/post/2008/07/03/How-to-Floor-an-SQL-datatime.aspx#id_16d7e226-1554-44e4-8b9e-0dec2d90ceaf http://www.thewayithink.co.uk/post/2008/07/03/How-to-Floor-an-SQL-datatime.aspx#id_16d7e226-1554-44e4-8b9e-0dec2d90ceaf#comment http://www.thewayithink.co.uk/syndication.axd?post=16d7e226-1554-44e4-8b9e-0dec2d90ceaf