Close Wes. its Datepart('h',datetimevalue)*3600 + Datepart
('n',datetimevalue)*60+Datepart('s',datetimevalue) as total_secs
but your idea triggered my memory ;-)
Thanks, Jeremy
-----Original Message-----
From: "Wes Edwards" <[EMAIL PROTECTED]>
To: "'NZ Borland Developers Group - Delphi List'" <[EMAIL PROTECTED]>
Date: Thu, 18 Dec 2003 12:35:29 +1300
Subject: RE: [DUG] Slightly off topic - sorry
> Datepart('s',datetimevalue)
>
> > -----Original Message-----
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] On Behalf Of vss
> > Sent: Thursday, 18 December 2003 11:59 a.m.
> > To: [EMAIL PROTECTED]
> > Subject: [DUG] Slightly off topic - sorry
> >
> >
> > HI all.
> > I was wondering if anyone knows how I can convert a TIME to
> > SECONDS in
> > MSAccess?
> >
> > Thank, Jeremy
> >
> > _______________________________________________
> > Delphi mailing list
> > [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
> >
>
>
> _______________________________________________
> Delphi mailing list
> [EMAIL PROTECTED]
> http://ns3.123.co.nz/mailman/listinfo/delphi
_______________________________________________
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi
