How can you display the current date & current time ?

Answer Posted / prabu

select getdate()

In SQL Server, We can get current date and time
If this answer is not correct give me feedback

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

is it compulsory commitment control in journal?

2242


I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2162


What is ibm db2 database?

739


What are the bind parameters ibm db2?

825


What type of database is db2?

724


How to get the ddl of a table in db2?

878


what is a corelated subquerry?

844


How to fetch the last row from the table in SQL (db2)?

1334


Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

2132


Which isolation level provides highest data integrity?

826


What is phantom read in db2?

846


How will you return the number of records in table?

718


What is host variable in db2 cobol?

823


Is db2 a database?

757


define clustering index.

812