Saltar al contenido principal



Date/Time Formatting in Database


1 comentario

  • Avatar
    Peter Thane

    I think if you change the Data Type to Time then that should sort it for you. 

    I could be wrong, but my guess is the ODBC driver automatically sends it through as a date and time field, but hopefully the above will strip off the date element.

    (Not sure if you can use the Transforms>Offset functionality to perform the subtraction for you as the amount to adjust can come be constant or taken from other sources) 


Iniciar sesión para dejar un comentario.