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 |
|
pkolar
Starting Member
1 Post |
 Posted - 2002-02-15 : 18:49:49
|
| In VB,there is a dateserial function which does a whole of functions, like getting the first day of month, last day of the month,etc. Is there any function similar to that which can be used in writing a stored procedure in MS SQL Server?Thanks |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-02-15 : 19:31:15
|
| I believe DateAdd and DatePart will be the functions you're looking for. You can look them up in BOL. For First-Day-Of-Month and Last-ay-Of-Month functions, you can write your own SQL functions to do that if you have SQL 2000. In fact, the code for that was posted here in our Scripts Forum.------------------------GENERAL-ly speaking... |
 |
|
|
|
|
|
Date Serial Function