Designer-SQL Editor- Convert Datetime to Date

balachandra2164

Hi  Team,

I am trying to convert datetime format to date

input: YYYY-MM-DD HH:MM:SS (datetime)  

output expected: YYYY-MM-DD

Input:

I have tried convert and cast as well but couldn't able to retrieve info as '2015-01-01'. Please advice

Note: I am using Oracle database as input

JarekSkudrzyk

@balachandra2164 hi, please try using Date format (not DateTime) - it should give output without hours/minutes/seconds