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
is it compulsory commitment control in journal?
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?
What is ibm db2 database?
What are the bind parameters ibm db2?
What type of database is db2?
How to get the ddl of a table in db2?
what is a corelated subquerry?
How to fetch the last row from the table in SQL (db2)?
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 .....
Which isolation level provides highest data integrity?
What is phantom read in db2?
How will you return the number of records in table?
What is host variable in db2 cobol?
Is db2 a database?
define clustering index.