Extract hour from date problems

1

It seems extract hour from date always return 0

SELECT HOUR(CURRENT_DATE())

image
image1494×641 24.5 KB

SELECT DATE_PART('hour',CURRENT_DATE())

image
image1458×607 23.9 KB

2

current_date() only returns a date. If a date gets casted to a timestamp you will receive this:
select cast(current_date() as timestamp) → 2024-01-04 00:00:00.000

Instead of current_date(), you should use the now() function which is a timestamp and contains the time.

So this query would resolve your problem:
select hour(now())

1 Like
3

Thanks for your helping, obviously I misunderstood the date, Thanks again!