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!"