File metadata and controls Code Blame 21 lines (15 loc) · 611 Bytes Raw --To extract specific value from a column --Here I extract only year from payment_date and save it to pay_year varriable select ...

CURRENT_TIMESTAMP (Transact-SQL) [!INCLUDE sql-asdb-asdbmi-asa-pdw] This function returns the current database system timestamp as a datetime value, without the database time zone offset.