How do we get current date in SQL Server 2000, Oracle, MS
Access?
- 13 Answers
- 50558 Views
- I also Faced
- E-Mail Answers
Answer Posted / selvaraj.v
In Access 'Select date()'
In Oracle 9i 'Select Sysdate from dual;'
In SQL Server 2000 'Select Getdate()'
| Is This Answer Correct ? | 33 Yes | 7 No |
Post New Answer View All Answers
How do you debug a procedure in sql server?
Where views are stored in sql server?
How can you set the threshold at which sql server will generate keysets asynchronously?
What is a unique index?
What is dbcc updateusage?
what does the automatic recovery do? : Sql server administration
What is difference between equi join and inner join?
What is data source in connection string?
Explain about SQL server 2005?
What it means to be triggered?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
What is the purpose of data source?
Explain encryption of entire databases without the need for application changes in sql server 2008?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
Explain something about security and SQL Azure?
