Example 9: Convert date string in DD-MON-YY HH:MI:SS(12 Hour) format to timestamp datatype.SYNTAX: SELECT TO_DATE('27','DDD-Mon-YYYY') Example 8: Convert date string in DDD-MON-YY format to date datatype, DDD-> Day of year.SYNTAX: SELECT TO_DATE('11-Oct-19 Friday','DD-MON-YY DAY') Example 7: Convert date string in DD-MON-YY DAY format to date datatype.SYNTAX: SELECT TO_DATE('11-Oct-19 Fri','DD-MON-YY DY') Example 6: Convert date string in DD-MON-YY DY format to date datatype.SYNTAX: SELECT TO_DATE('12-October-19','DD-MONTH-YY') Example 5: Convert date string in DD-MONTH-YY format to date datatype.SYNTAX: SELECT TO_DATE('1','DD-MON-YYYY') Example 4: Convert date string in DD-MON-YYYY format to date datatype.Example 3: Convert date string in DD-MON-YY format to date datatype. ![]() Example 2: Convert date string in DD-MM-YYYY format to date datatype.Example 1: Convert date string which is not in irregular format.Various character and character strings (Metacharacters) are available in Teradata which can be used along with TO_DATE / TO_TIMESTAMP functions to convert strings into date/timestamp datatypes.īelow tables show most of the metacharacters that can used with TO_DATE / TO_TIMESTAMP function.Ĭonvert year in four digits(example: 1987)Ĭonvert month of the year in number format(example: 12)Ĭonvert month in 3 characters format(example: Jun)Ĭonvert full month name(example: June) formatĬonvert day of the month in two digits(example: 30)Ĭonvert hour of the time in two digits(example: 17)Ĭonvert minutes of the time in two digits(example: 59)Ĭonvert seconds of the time in two digits(example: 58)Ĭonvert day of the week in 3 characters(example: Wed)Ĭonvert full name of week day(example: Wednesday)Ĭonvert string timestamp with AM/PM formatĪll the below examples can be used convert strings into DATE/Timestamp datatypes Teradata support ANSI Format to convert date/timestamp strings into date / timestamp datatypes.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |