Try following queries 1] get date time "SELECT NOW()" 2] get

how to get server date and time?

Question Posted / arya

Answer Posted / arya

Try following queries

1] get date time
"SELECT NOW()"
2] get time
"SELECT CURTIME()"
3] get date
"SELECT CURDATE()"

Is This Answer Correct ?

12 Yes

9 No

Please Help Members By Posting Answers For Below Questions

What are the advantages of stored procedures in php?

566

What is the special meaning of __sleep and __wakeup?

648

A process can run only in the background. State Whether True or False?

711

Explain the difference between static and dynamic websites?

589

What is difference between sql and php?

646

What is difference between explode() or split() in PHP?

571

How to check an element is exists in array or not in php?

668

Describe PHP error and logging information?

619

What is action hooks and filter hooks?

581

How escape single quotes php?

569

How to generate a form?

694

What is the function used to change the root directory in PHP?

643

Explain me the difference between include and require?

593

is that "enumerated array" equal to "numeric array"?

2117

Explain me what is the goto statement useful for?

557