| Author: andy robarts 28 Apr 2008 | Member Level: Gold Points : 2 |
select syadate from dual;
|
| Author: Dainy Patel 30 Apr 2008 | Member Level: Gold Points : 2 |
plz go to this link
http://www.mydatabasesupport.com/forums/sybase/130579-dbd-sybase-datetime.html
|
| Author: andy robarts 30 Apr 2008 | Member Level: Gold Points : 2 |
select syadate from dual;
|
| Author: Sridevi Nagalingam 02 May 2008 | Member Level: Silver Points : 2 |
select getdate()
|
| Author: Nithya 02 May 2008 | Member Level: Bronze Points : 2 |
There are three ways to retrieve the current datetime in SQL SERVER.
CURRENT_TIMESTAMP, GETDATE(), {fn NOW()}
SELECT CURRENT_TIMESTAMP
GO
SELECT {fn NOW()}
GO
SELECT GETDATE()
GO
|
| Author: Bunty 10 May 2008 | Member Level: Diamond Points : 2 |
select GetDate()
|
| Author: Sonu Fernandes 21 May 2008 | Member Level: Gold Points : 2 |
Simple in SQL Server we have some pre-defined Function
To get Current Date of the System, just call the getdate() Function
Ex: select getdate()
|
| Author: T.Thirumala Reddy 22 Oct 2008 | Member Level: Bronze Points : 0 |
select getdate()
|