Re: [Question] I want to get the system date and time
Posted in 1998
Peter Lancashire — — source: Informix-list mailing list archive (1991-1998)
'̵''' wrote:
>
> I want to get the system time not by PC but server using
> SQL statements.
> DBMS whitch I use is Informix.
> If anybody know this, please send me a Mail.
> I appreciate it previously.
> I hope you have a luck!!
> E-Mail Address : dongsam@samsung.co.kr
Try:
select current from systables where tabid = 1;
--
Peter Lancashire
Information Systems Specialist, Bayer plc
Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK
Tel: +44-1635-562258, Fax: +44-1635-562281
Mail: Peter.Lancashire.PL1@bayer.co.uk
---
My Internet plumbing does not allow me to mail and post news together.
Sorry.
All opinions are my own and not those of Bayer plc.
---
Join Infuse, the UK Informix User Group at http://www.infuse.co.uk/