How to change Timestamp format to MM-DD-YY?
Is this possible? I have tried trunc, to_char, ::date. All of these still populate the timestamp date in the result.
Hi Nate ,
It would depend on the SQL database you are using, but you should be able to do it with most databases using a CAST method. Let me know if you have any questions or if you can provide the database I can make a direct recommendation.
Jonathan Rosario Thank you! The database is Amazon Redshift which is using PostgreSQL.
I also tried CAST with no luck.
try the to_char with substring to get YY not YYYY :)
208 Utah Street, Suite 400
San Francisco CA 94103