Database Administration Fundamentals (SF21SQL1001) – Day 3

We continue manipulating data (without making changes in the database). We have covered functions that affect strings and numeric values — including `FORMAT()` to change currency and date values.

  FORMAT(numeric_value, format_needed, culture)
  FORMAT(numeric_value_money, 'c', 'en-us')
  FORMAT(numeric_value_date,  'd', 'en-us')
  FORMAT(numeric_value_date,  'D', 'en-us')

Download the class notes for day 3.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.