Jump to content
Thomasha

SQL deptime -1 Hour

Recommended Posts

Hello Guys,

we in our Airline got our complete schedule in utc time.

At the end of the Month we are switching to the "wintertime" and so we must reschedule all Flights.

Is there an way that we can change all Flights in mysql to be set deptime -1 Hour ???

Thanks in advance for your help.

BRGDS

Edited by Thomasha

Share this post


Link to post
Share on other sites

If all times are already in UTC, there is no need to change the times. UTC stays the same year round and is not predicated on summer/winter time changes.

Edited by ProAvia

Share this post


Link to post
Share on other sites

Hi ProAvia, thanks for your answer.

In our case the departure time in local stays the same. i.E. DEP EDDF is always 07:00 loc which means in summer 05:00UTC and winter 06:00UTC

Share this post


Link to post
Share on other sites

I lost you to be honest what you are writing now means that you don't use utc times

Share this post


Link to post
Share on other sites

Hi Vangelis.

The real dep time is always 07:00local.

That means in the wintertimetable we must enter it as 06:00UTC and in summer as 05:00UTC.

Thats why I asked if there is an way to change the times via sql :-)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×