Insert Date inside mysql column
#3

Quote:
Originally Posted by vassilis
Посмотреть сообщение
Mysql has a function that is called NOW and prints the current time the command happens.

EDIT: for example at my bug report command here is my mysql_format

PHP код:
mysql_format(mysqlquerysizeof(query),"INSERT INTO `bugs` (`BugReporter`,`BugInfo`,`Date`) VALUES ('%s','%s', NOW())",BugReporter,BugInfo); 
Mhm.. interesting, and how can I insert ExpireDate 30 days from "NOW"(date when that happened), is it even possible ?
Reply


Messages In This Thread
Insert Date inside mysql column - by CoachCarter - 07.10.2016, 05:10
Re: Insert Date inside mysql column - by vassilis - 07.10.2016, 05:12
Re: Insert Date inside mysql column - by CoachCarter - 07.10.2016, 05:15
Re: Insert Date inside mysql column - by vassilis - 07.10.2016, 05:22
Re: Insert Date inside mysql column - by CoachCarter - 07.10.2016, 05:33
Re: Insert Date inside mysql column - by Vince - 07.10.2016, 05:33
Re: Insert Date inside mysql column - by CoachCarter - 07.10.2016, 05:52
Re: Insert Date inside mysql column - by CoachCarter - 07.10.2016, 06:43

Forum Jump:


Users browsing this thread: 1 Guest(s)