Link to home
Start Free TrialLog in
Avatar of Ernesto
ErnestoFlag for Mexico

asked on

Remove the hour from date time format

Hi all
this one put me the date with hour

SELECT max(CONVERT(datetime, fecha, 103))

i want it whitout hour
is any way
tsm you experts
regards
Avatar of Scott Pletcher
Scott Pletcher
Flag of United States of America image

SELECT max(CAST(fecha AS date))
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.