How to get System Date & time from MySql5.0 server?Becoz I using Storedprocedure in C# code .?

I using C# Mysql5.0 . I want to get a date from server. I m using storedprocedures in C#.pls help

How to get System Date %26amp; time from MySql5.0 server?Becoz I using Storedprocedure in C# code .?
Hey it's easy


select now(); result: 2008-02-07 19:42:00 gives both datetime





select curdate(); result: 2008-02-07 gives date


select curtime(); result:19:42:00 gives time





If u are not passing datetime values in the table as parameters save it as %26lt;yourdatetimevalue%26gt;.ToString("s")





Enjoy Programming.........