RE: in SQL query can we use sysdate to get System date

2001-05-10 Thread Don Read


On 10-May-01 AVDHUT SHEDGE wrote:
> in SQL query can we use sysdate to get System date like Oracle

mysql> select SYSDATE(); 
+-+
| SYSDATE()   |
+-+
| 2001-05-10 05:46:28 |
+-+

Does Orkcle have manuals ?

Regards,
-- 
Don Read   [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to 
   steal the neighbor's newspaper, that's the time to do it.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: in SQL query can we use sysdate to get System date

2001-05-10 Thread Peter Pentchev

On Thu, May 10, 2001 at 10:24:11AM -, AVDHUT SHEDGE wrote:
> in SQL query can we use sysdate to get System date like Oracle

What's wrong with NOW(), as seen in the manual?
Reference >> Functions >> Date and Time Functions

Next time, take a look there :)

G'luck,
Peter

-- 
"yields falsehood, when appended to its quotation." yields falsehood, when appended to 
its quotation.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




in SQL query can we use sysdate to get System date

2001-05-10 Thread AVDHUT SHEDGE

in SQL query can we use sysdate to get System date like Oracle

_
Chat with your friends as soon as they come online. Get Rediff Bol at
http://bol.rediff.com





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php