> Problem:
> Example: When you insert (or update) a record to the system, it shows the
> the EventDate in the database as 08/25/00. The times, however, show as
> 6/20/00 9:00:00 AM and 6/20/00 10:00:00 AM, showing the date the data was
> entered. Output is fine at this point if all the data for that
> EventDate are entered on the same day (06/20/00).
>
> If someone updates the record on another day, say 06/21/00, the
> sorting gets screwy. It now puts all times with the new, updated
> date in the EventStart and StopTime fields at the end.
>
> Question:
> Is there a simple way to store JUST the time in a DateTime
> datatype field. I would have thought that is what CreateODBCTime
> was for, but apparently not.
> Or should I just use a char field for this.
OK, here's the rub - DateTime fields are exactly what they say - Date and
Time
The reason that the Date-only field works is that the time part is midnight,
so it doesn't need to show it, but if you asked for it in full format, it'd
be there
Why would the sorting get messed up? Since you're sorting by EventDate, and
then EventStartTime, it should still sort into the right order
If I was you, I'd stick a specific date onto the start of the EventStartTime
and EventEndTime so that you can just remove it
Of course, when you sort it, you could just use the relevant DateParts;
ORDER BY EventDate, DatePart(hh,EventStartTime), DatePart(mi,EventStartTime)
Just some thoughts that might help you...
Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
