Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pamyral_279
Posting Yak Master
143 Posts |
 Posted - 2006-02-17 : 04:54:43
|
| I need some links which guide datetime in sql statement !!Such as : I have a datetime column in my table , I need to calculatethe total orders in the today, or yesterday ...Any one know ?Thank you very much . |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-02-17 : 05:11:50
|
| Just google SQL Server Datetime and you will find lots of this.like :http://www.sql-server-performance.com/fk_datetime.asphttp://www.databasejournal.com/features/mssql/article.php/2191631----------------------------------'KH'Time is always against us |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-02-17 : 05:23:12
|
| Also read about DateDiff, DateAdd, Group by in SQL Server help fileMadhivananFailing to plan is Planning to fail |
|
|
|
Kristen
Test
22859 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
pamyral_279
Posting Yak Master
143 Posts |
Posted - 2006-02-18 : 05:57:12
|
| Thank you people here !!This is wonderful place.I will save a lot of time.Thank you very much. |
|
|
|
|
|
|
Some links guide datetime in sql !