Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

System Date 1

Status
Not open for further replies.

Diogo

Technical User
Mar 22, 2001
143
PT
Hello!

Whow can i return the system date in a sql?

Tanhs any way.

DR
 
Hi,

Use TODAY keyword for date, and CURRENT for datetime information.

select today from systables where tabid=1;
select current from systables where tabid=1;
select today, current from systables where tabid=1;

Regards,
Shriyan
"Man who knows, knows, he knows nothing!"
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top