Depends.. will this be entirely CF and does the client's time matter? We have a Flex/Java/Oracle schedule app that at first used dates/times but trying to work with clients time versus the server's time was a headache.. Anyways we switched pretty quickly to having a year column, weeknbr column, day column (day of week) and then the starttime and endtimes were numbers e.g. 13.5 would be 1:30pm.. then we didnt have to worry about client/server times..
On Tue, Apr 22, 2008 at 1:25 PM, Nate Willard <[EMAIL PROTECTED]> wrote: > Hello, > > > I'm working to build a system that stores a set of records every week. Can > anyone offer suggestions on how to best save these records in the DB? > > > Should I have a column 'datetime' and have the result be the Sunday of the > week, for example this week's records all with the datetime: 4/20/2008 > > > or Should I use CF's Week() function and store the week number, which I > believe is currently 17. > > > I'm looking for your advice to prevent issues when I want to access the data > later down the road. > > > Thanks > N > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304001 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
