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
@balachandra2164 hi, please try using Date format (not DateTime) - it should give output without hours/minutes/seconds