sql server - storing time and day of week -


challenge : have requirement in have implement recurring events. storing day of week , time , date range event reoccur.

possible solution: storing time , day of week string , enumeration. storing current , setting time , day day ?

question : best practice on storing time , day of week ?

edt: using sql server database

this best approach might dependson database using. but, there 2 general approaches, both quite reasonable.

the first store dates , times in native format database. databases have functions extract day of week , time date time type. write queries using these functions. typically, store these 1 field, might want separate date , time portions.

the second have calendar table. calendar table have date or dateid key, , contain columns want know it. day of week obvious column.

a calendar table preferred solution in situations. instance, if going internationalize application, being able day of week table makes easier string english, greek, chinese, russian, swahili, or whatever favorite language is. or, if want keep track of specific holidays, calendar table can store information well. or, if have business running on strange financial calendar (such 5-4-4), calendar table choice.

in either case, not need store redundant date information in table. should derive it, either built-in function or looking want in reference table.


Comments

Post a Comment

Popular posts from this blog

java - Play! framework 2.0: How to display multiple image? -

i need display gallery of photos. here template: @(photos: list[photo]) @title = { <bold>gallery</bold> } @main(title,"photo"){ <ul class="thumbnails"> @for(photo <- photos) { <li class="span3"> <a href="#" class="thumbnail"> <img src="@photo.path" alt=""> </a> </li> } </ul> } and here controller method: public static result getphotos() { return ok(views.html.photo.gallery.render(photo.get())); } and here photo bean : @entity public class photo extends model { @id public long id; @required public string label; public string path; public photo(string path, string label) { this.path = path; this.label = label; } private static finder<long, photo> find = new finder<long, photo>( long.class, photo.class); public static list<phot...
Read more

gmail - Is there any documentation for read-only access to the Google Contacts API? -

i want read-only access user's google contacts. there stackoverflow member wanted this, , received following answer : yes, there is, use https://www.googleapis.com/auth/contacts.readonly scope , "view contacts". this exchange reference read-only access google contacts can find using google. simply using access token obtained attempt read usual google contacts api (i.e. https://www.google.com/m8/feeds ) fails insufficient permissions. similarly, using google contacts api on new target fails 404 errors (for example https://www.googleapis.com/auth/contacts.readonly/default/full ). is there documentation anywhere on how use api, or permissible way access google contacts api full read-write access?
Read more

php - Controller/JToolBar not working in Joomla 2.5 -

relevant code: jtoolbarhelper::custom('savecategories', 'save', '', 'save', false, false); ... <input type="hidden" name="controller" value="easyblogcontroller"> according can dig docs , own previous questions, should call savecategories() function in easyblogcontroller . i've tried setting value easyblog , easyblog.php (file name) current easyblogcontroller (class name). clicking on save button refreshes page. not redirect, echo or var_dump test code put in savecategories() function. var_dump ing jrequest::getvar('controller') , 'task' return correct values. creating controller object , using $controller->execute('task'); works. the values going depend on location of controller trying call, , have couple options here. typically there controller in base folder of component (likely components/com_easyblog) in file called controller.php , class name inside ...
Read more