Can't convert to date!

[Josh]

This is driving me crazy! What am I doing wrong?

Code: Select all

dbadmin=> select to_date(20140613, 'YYYYMMDD');
ERROR 3457:  Function to_date(int, unknown) does not exist, or permission is denied for to_date(int, unknown)
HINT:  No function matches the given name and argument types. You may need to add explicit type casts

That is a valid date!

[JimKnicely]

The TO_DATE function only accepts VARCHARs as input parameters:

Code: Select all

dbadmin=> \df to_date
                         List of functions
 procedure_name | procedure_return_type | procedure_argument_types
----------------+-----------------------+--------------------------
 to_date        | Date                  | Varchar, Varchar
(1 row)

Try converting your INT to a VARCHAR:

Code: Select all

dbadmin=> SELECT TO_DATE(20140613::VARCHAR(8), 'YYYYMMDD') AS "Friday the 13th!";
 Friday the 13th!
------------------
 2014-06-13
(1 row)

[Josh]

Arghhhhh! Thanks, Jim! That was what I was missing...