janaka.co.uk

MySQL INSERT & UPDATE date mask

13 March 2010

Use ‘yyyy-MM-dd  HH:mm:ss’ as the date mask (i.e. format the date using this format string) in insert and update statements.


Personal blog by Janaka Abeywardhana. Thoughts on topics other than Software Engineering and Product Management. All of that is over at [janaka.dev](janaka.dev) by Janaka Abeywardhana. On Github, Twitter, and Instagram

© 2000-2021. Built with Gatsby. Deployed on the Distributed Web using IPFS and Fleek