How to display system time if the time is 20:00 then it will display 2000 format
Hi you can use replace function to replace : with '' after casting systime() to character. If it doesn't work then create this calculation
cast(extract(Hour,systime()),varchar(10))+''+cast(extract(minute,systime()),varchar(10)). only check the time format what you want means 12 or 24 hour.