How can you display the current date & current time ?
- 7 Answers
- 11785 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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
What is temporal table in db2?
How to create backup table in db2?
How do I create a view in db2?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
i want to maintain uniqueness on pdf without make lf??????????
Explain in detail about buffer manager and its functionalities?
What types of tables are there in the db2 database?
What is runstats db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
How to check last update on table in db2?
What is clone table?
What is db2 stogroup?
What is the reason behind not using select * in embedded sql programs?
can we view the access paths created by dbrm ? how ? thx
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 .....
