From: "Anvar Hussain K.M." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: 11 January 2002 04:05
Subject: Re: Date Field + Time Field = Datetime Field?
> Hi Alex,
>
> I don't think your problem will solved by making the time columns to full
> datetime c
Hi Alex,
I don't think your problem will solved by making the time columns to full
datetime columns as there is no
functions to subtract two datetime values directly.
But you can can keep the time columns and go on like this:
convert the time into seconds using time_to_sec function.
subtract f
I've been working with a timesheet database, where all the employees of my
small business enter in the hours they work on projects. I've been storing,
for each record, a date of work, a start time, and a finish time.
When I attempted to write a Perl script to display invoices, though, I ran
i