Member Avatar for vizz

I have Date in format: 12, August, 2011 and Time : 09:11:02

I am using following for Date

date("j, F, Y");

and following for time

strftime("%I:%M:%S")

How to create database and insert date & time as it is into MySql ?

  • 2 Contributors
  • 1 Reply
  • 100 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas

MySql expects '2011-08-12 18:35' or you can use the MySql function NOW() in your query.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.