Menu
Is there an equivalent to this T-SQL command in PostgreSQL?
select dateadd(hh,duration_in_hours,start_date) as end_date I have found only interval keyword with subsequent string, but this terrible construction returns syntax error:
select start_date + interval cast(duration_in_hours as varchar) || ' hours' It allows only string constant after "interval " keyword. I am sure there must be some similar function in pgsql, but I cannot find it.
911
Q. Where are the DATEADD and DATEDIFF functions in PostgreSQL? A. There are none.
The DATE_ADD() function adds a time/date interval to a date and then returns the date.
PostgreSQL supports a CAST operator that is used to convert a value of one type to another. Syntax: CAST ( expression AS target_type ); Let's analyze the above syntax: First, specify an expression that can be a constant, a table column, an expression that evaluates to a value.
You can do it like this:
select start_date + (duration_in_hours * interval '1 hour') from your_table See this sample SQL Fiddle
65
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
