vielleicht hilft die TIMESTAMP Funktion weiter?

The TIMESTAMP function returns a timestamp from a value or a pair of values.

The rules for the arguments depend on whether the second argument is specified.


If only one argument is specified:
It must be a timestamp, a valid string representation of a timestamp, or a character string of length 14.

A character string of length 14 must be a string of digits that represents a valid date and time in the form yyyyxxddhhmmss, where yyyy is year, xx is month, dd is day, hh is hour, mm is minute, and ss is seconds.


If both arguments are specified:
The first argument must be a date or a valid string representation of a date; the second argument must be a time or a valid string representation of a time.

The result of the function is a timestamp. If either argument can be null, the result can be null; if either argument is null, the result is the null value.
Gruss und HTH
Rolf