How do you offload the time/date handling to MySQL?

Recommended Answers

All 2 Replies

What do you mean by offload?

most table updates can be done with mysql now, that stamps the current timestamp to the field
and output from the timestamp any which way you like with regular date functions
google MYSQL NOW to find the correct code for your app

do not use any text date time function, it will be wrong in 2/3 of the world, numeric timestamp can be formatted to user preference for every user regardles of whether they expect dd mm yyy, mm dd yy, YYY MMM dd, dd MMM yy or any other date format.

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.