convert data type in sql
# There are two ways to change data type. By using CAST or ::
# Eg. CAST (column_name AS target_type) OR column_name::target_type
SELECT
CAST (date_occurred AS DATE)
CAST (total_amount AS INTEGER)
CAST (duration AS INTERVAL)
# OR
date_occurred::DATE
total_amount::INTEGER
duration::INTERVALsql server convert string to date
Cast( '2011-07-07' as date ) as convertedDateCopyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
