2 Replies Latest reply on Jan 23, 2009 12:36 PM by Dan Bracuk

    Proper formatting for writing to the DateTime field in mySQL

    gigasaurus Level 1
      I need to timestamp or set particular dates which I will be writing to a datetime field in a mySQL database.

      The format for that looks like this: 2009-01-23 01:01:01

      I am able to write to the field by formatting like this: dateformat(Now(), "yyyy-mm-dd hh:mm:ss")

      The problem is the "minutes" take on the "month" value (because I'm using the letter "m" in both places). Is there another letter other than "m" that I should be using for minutes? I have a reference book that says "n" but that didn't work. I'll attach the basic code below.