ReadVitamin

How to use EXTRACT function with date and time columns

Using Extract function with any date field is easy. Let’s try this out with system date and system time commands. To see the current date we use SELECT DATE; This would give output as "11/06/2007". Suppose you want to EXTRACT the month from the date then use this query SELECT EXTRACT (MONTH FROM date); This would give "11" as the output. Similarly for YEAR and DAY use the following commands SELECT EXTRACT (YEAR FROM date); SELECT EXTRACT (DAY FROM date); But for [+]

Usage of Macro in Teradata

A macro is created to execute a single or a set of SQL statements in a single execution. Each time the macro is run all of the SQL statements present inside the macro are executed and results are returned after the end of all the SQL present inside the macro. Why do we need a macro? If there is a set of frequently used SQL statement which are being repeatedly executed, this set of SQL statement [+]