Jump to content

Change parts of the datetime stamp


Recommended Posts

Hi,

I've got a table with waypoints in my db (called points), these waypoints combine to a route due to the the timestamp in the start and stop column.
Now I would like to change the date and/or date + hour to use the track on a different date or start at a differnt hour. But i also would like to keep the intervals between the records.

ID    Name    Lat    Lon    Start    Stop
526    Waypoint X    52.14722000    6.39720000    2020-03-30 20:37:32.0    2020-03-30 20:47:32.0
527    Waypoint Y    52.14670000    6.39139000    2020-03-30 20:47:32.0    2020-03-30 20:52:32.0
528    Waypoint Z    52.14248000    6.39125000    2020-03-30 20:52:32.0    2020-03-30 20:57:32.0
529    Waypoint X    52.14722000    6.39720000    2020-03-30 20:57:32.0    2020-03-30 21:02:32.0
530    Waypoint Y    52.14670000    6.39139000    2020-03-30 21:02:32.0    2020-03-30 21:07:32.0
531    Waypoint Z    52.14248000    6.39125000    2020-03-30 21:07:32.0    2020-03-30 21:12:32.0
532    Waypoint X    52.14722000    6.39720000    2020-03-30 21:12:32.0    2020-03-30 21:17:32.0
533    Waypoint Y    52.14670000    6.39139000    2020-03-30 21:17:32.0    2020-03-30 21:22:32.0
534    Waypoint Z    52.14248000    6.39125000    2020-03-30 21:22:32.0    2020-03-30 21:27:32.0
535    Waypoint X    52.14722000    6.39720000    2020-03-30 21:27:32.0    2020-03-30 21:32:32.0
536    Waypoint Y    52.14670000    6.39139000    2020-03-30 21:32:32.0    2020-03-30 21:37:32.0

Is it possible to use an update querey to change only a part of a datetime stamp? See the colored examples shown below.

  • 2020-03-30 20:37:32.0
  • 2020-03-30 20:37:32.0

Thanks in advance for your help.

Arjan

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...