Ernesto
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
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
SELECT max(CAST(fecha AS date))
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers 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.