You are here
Home > Posts tagged "Date and time functions"

Date and Time Functions in sql

Date and Time Functions

Date and Time Functions T-SQL supports a many date and time functions that allow you to manipulate your date and time data. Current date and time T-SQL supports built- in functions like GETDATE, GETUTCDATE, CURRENT_TIMESTAMP, SYSDATETIME, SYSUTCDATETIME and SYSDATETIMEOFFSET that returns the current date and time. CURRENT_TIMESTAMP: Returns the current date and

SQL Server Functions in sql

SQL Server Functions T-SQL supports many built-in functions. Scalar function returns a single value. Table-valued function returns a table result.  Conversion functions SQL supports number of functions that can convert a source expression to a target data type. SQL Server conversion functions are CAST and CONVERT. CAST: It converts an expression from one