A table is having column called 'Timestamp', whose data type is timestamp(6)and stores the value '01-jan-2009 14:12:15'. When this column is pulled into the WEBI report, then the output will be '01-jan-2009'.

Keep practicing — related questions

• Oracle DATE columns always contain the date but not the time fields.
• For date and time stamp queries if the value is null then what is returned for low-date and low-timestamp
• For date and time stamp queries if the value is null then what is returned for low-date and low-timestamp
• state true or false can we apply Round() to the column whose datatype is declared as DATE?
• SQL data type DATE, TIME or TIMESTAMP will be accdepted as character strings in COBOL program
• Following datatype cannot be used twice in a table.
• Oracle DATE columns always contain the date but not the time fields
• In the Datatype Conversions Date can be converted only to date and string and vice versa.