sql server - Date serial in SQL? -


how do I one day [1-31] ​​and one month [1-12] and one year (all int) Can I change? A date serial in these SQL (without converting into varchar)?

Zero 1 January 1900 is in SQL, so you can use it:

  DATEAD (day, @delge -1, DATEADD (month, @ month-1, DATEADD (year, @ year-1900, 0))  

Comments

Popular posts from this blog

c# - sqlDecimal to decimal clr stored procedure Unable to cast object of type 'System.Data.SqlTypes.SqlDecimal' to type 'System.IConvertible' -

Calling GetGUIThreadInfo from Outlook VBA -

Obfuscating Python code? -