Just wondering if I was running an update query for example called
post_postdate='TIME GOES HERE'
What kind of function or whatever could I use to include the date?
Have you looked at the documentation for your database server? Maybe it has a function called "NOW()" or something like that.
