07-31-2023, 07:54 AM
Just in case anyone is looking in here for a Sybase version since several of the versions above didn't work
CAST(CONVERT(DATE,GETDATE(),103) AS DATETIME)
- Tested in I SQL v11 running on Adaptive Server 15.7
CAST(CONVERT(DATE,GETDATE(),103) AS DATETIME)
- Tested in I SQL v11 running on Adaptive Server 15.7