Can I read Date Formatting in SQL and Oracle on EtoBox?

Date Formatting in SQL and Oracle by Harry Konnect is a document available to read on EtoBox.

What is Date Formatting in SQL and Oracle about?

This document provides examples of SQL and Cognos date functions for formatting dates as strings in different formats like MM/DD/YYYY. It includes functions for Microsoft SQL Server, Oracle, and Cognos to get dates like the first/last day of the month, week, or year. Useful links are also provided on using the Cognos periodsToDate function and dimensional modeling for time periods. Sample queries demonstrate calculating YTD, QTD, HTD measures and formatting amounts as currency.

Author

Harry Konnect

Language

EN