Eclipse Community Forums: BIRT » birt sql add hour

Home

Home » Archived » BIRT » birt sql add hour(birt sql add hour)

birt sql add hour [message #1836167]

Tue, 22 December 2020 22:09

Eclipse User

dear sir

what is the sql command for add hour in Birt

Thanks

Re: birt sql add hour [message #1836222 is a reply to message #1836167]

Thu, 24 December 2020 11:10

Eclipse User

SQL depends on what database you are using. You can also use the 'AddHour' command under the BirtDateTime function.

MySQL = SELECT DATE_ADD(myDate, INTERVAL 1 HOUR);

Previous Topic:	Data Set Troubles
Next Topic:	Data Sets -> Generate SQL Views

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Apr 25 09:46:32 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter