How to use to_char function in Oracle

You will use the below SQL to use to_char function correctly.

select first_name, last_name,
to_char(hire_date, 'Day, Month DDTH, YYYY') formatted_hire_date
from hr.employees;

Results from our TO_CHAR formatting appear with the correct day name, month name and other desired formatting in place.
FIRST_NAME            LAST_NAME       FORMATTED_ HIRE_DATE
-------------------   -----------     --------------------
Donald                OConnell       Monday,June 21ST, 1999
Douglas               Grant          Thursday,January   13TH, 2000
Jennifer              Whalen         Thursday,September 17TH, 1987
Michael               Hartstein      Saturday,February  17TH, 1996
Pat                   Fay            Sunday,August    17TH, 1997

Comments

Post a Comment

Popular posts from this blog

Top myths for NULL value in SQL Queries

Image
The below are some of the key points about nulls, and how to compare them. Just to make sure that you should know about what is NULL value. Interpretation is not exactly missing value. There could be many reasons why no value is present, e.g., value inappropriate. How to compare NULL to values In the below example the where condition just checks for TRUE condition. If not matches you will get UNKNOWN. Example: Table Name is: Sells bar beer price ======================= Joe's bar Bud NULL SELECT bar FROM Sells WHERE price < 2.00 OR price >= 2.00; ------------ ------------- UNKNOWN Conclusion Joe's Bar is not produced, even though the WHERE condition is correctly given. The reason is the price value is NULL. So, we should not compare NULL to values.
Read more