Current Date and time

#1

------=_NextPart_000_0010_01C599BE.17702A70
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

I need to insert the current date and time into several tables. Can I use
the NOW() function and if so how do I call it? If not what is the best
solution?

------=_NextPart_000_0010_01C599BE.17702A70--

#2

Craig Snyder wrote:

Quote:

Can I use the NOW() function and if so how do I call it?

Treat it as any other query, using the Query class.

--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsu...ie.nctu.edu.tw

#3

Craig Snyder wrote:

Quote:

Is there a certain include file I need to add as when I compile the
application with the function in the query it does not understand that
function?

It's not a C++ function. It's SQL text:

Query q = conn.query();
q << "INSERT INTO whatever VALUES(NOW())";

This really has nothing to do with MySQL++, unless you want to add some
wrapper for this mechanism as a patch.

--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsu...ie.nctu.edu.tw

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Current Date and time

mailing.database.mysql-plusplus mailing.database.mysql-plusplus

Current Date and time - 08-05-2005 , 03:10 PM

Re: Current Date and time - 08-08-2005 , 05:20 AM

Re: Current Date and time - 08-09-2005 , 11:18 PM