Eclipse Community Forums: BIRT » birt sql add hour

Help

Home

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

Show: Today's Messages :: Show Polls :: Message Navigator

birt sql add hour [message #1836167]

Wed, 23 December 2020 03:09

chan chee keong

Messages: 1
Registered: September 2018

Junior Member

dear sir

what is the sql command for add hour in Birt

Thanks

Report message to a moderator

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

Thu, 24 December 2020 16:10

Jerry Sheets

Messages: 76
Registered: July 2009
Location: Salt Lake City, UT

Member

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);

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 05:38:39 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter