Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Roberto Filippi,
ufnDateTimeSerial returns the smalldatetime for year, month, day, hour, minute
ufnDateSerial returns the smalldatetime for year, month, day
ufnTimeSerial returns the smalldatetime for hour, minute (based on 1st january 1900)
ufnDateTimeSerial (year, month, day, hour, minute) is equivalent to ufnDateSerial (year, month, day) + ufnTimeSerial (hour, minute)
ufnStrCat and ufnStrRAlign are support utilities
smalldatetime data type usage
returning data for a given month
i am trying to insert the date in the format of mm/dd/yyyy.. But i keep getting the time in the colu...
Function to return the Month Name for month number input
SmallDateTime with Date only