7/30/2023 0 Comments Postico guidesTo_char(OrderDate,'DDD MM/DD/YYYY') As "DDD MM/DD/YYYY" To_char(OrderDate,'DAY MM/DD/YYYY') As "MM/DD/YYYY", To_char(OrderDate,'MM/DD/YYYY') As "MM/DD/YYYY", To_char(OrderDate,'DD.MM.YY') As "DD.MM.YY", ![]() To_char(OrderDate,'DD-MM-YYYY') As DDMMYYYY, SELECT Orderdetails,OrderDate as ExistingDateformat, ![]() Month abbreviation in all capital, first letter capitalized and all lowercase letters, respectivelyĭay name in all capital, first letter capitalized and all lowercase letters, respectivelyĭay of the week (Sunday (1) to Saturday (7))Ī few examples of different date formats are specified in the following SQL. Month name with the first letter capitalized The supported values in the to_char() function are as shown below. To_char(OrderDate,'DD-MM-YYYY') As NewDateFormat FROM SalesOrders The following query converts existing date values stored in the table into DD-MM-YYYY format.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |