5 Replies Latest reply on May 25, 2006 3:23 PM by SafariTECH

    sql date format

    macca2727
      Hi i have just changed my database from access to mysql, i have a insert action page which inserts a date and time

      now i have converted this insert is erroring there must be a different way with sql of inserting a date ?

      '#DateFormat(Now()) & ' ' & TimeFormat(Now())#'

      can anyone help