Member Avatar for srpa01red

i had a table productcs with stucture as pid,name,description,applications,created_at as datetime,updated_at datetime.
i will load the data from a csv file.now i want to insert the current timestamp while loading the data i.e the present time at which i am loading the data .is it possible to insert the current timestamp while loading the data in the field created_at

  • 3 Contributors
  • 2 Replies
  • 71 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by nav33n
Member Avatar for ithelp

have another field of type DATE , insert date() there.

Member Avatar for nav33n

is it possible to insert the current timestamp while loading the data in the field created_at

Yes. Use now() . date() doesn't work.

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.