type-casting-in-mysql.sql

#author          : Agung Pambudi
#email           : mail@agungpambudi.com
#version         : 0.1
#==============================================================================
#                                   _         _ _
# ___ ___ _ _ ___ ___ ___ ___ _____| |_ _ _ _| |_|  ___ ___ _____
#| .'| . | | |   | . | . | .'|     | . | | | . | |_|  _| . |     |
#|__,|_  |___|_|_|_  |  _|__,|_|_|_|___|___|___|_|_|___|___|_|_|_|
#    |___|       |___|_|



SELECT CAST(DATE_FORMAT(DATE(TANGGAL),'%Y-%m-%d') as date) FROM tablename;

SELECT DATE_FORMAT(STR_TO_DATE(TANGGAL, '%d-%m-%Y'), '%Y-%m-%d') AS TANGGAL FROM tablename;