Click here to Skip to main content
13,292,376 members (58,088 online)
   

Database

 
GeneralRe: Global Database Design for example to store Addresses Pin
Jörgen Andersson11-Oct-12 2:59
memberJörgen Andersson11-Oct-12 2:59 
GeneralRe: Global Database Design for example to store Addresses Pin
Eddy Vluggen11-Oct-12 5:42
memberEddy Vluggen11-Oct-12 5:42 
GeneralRe: Global Database Design for example to store Addresses Pin
Jörgen Andersson11-Oct-12 9:24
memberJörgen Andersson11-Oct-12 9:24 
GeneralRe: Global Database Design for example to store Addresses Pin
Eddy Vluggen11-Oct-12 11:09
memberEddy Vluggen11-Oct-12 11:09 
Jörgen Andersson wrote:
If there wasn't a date type available I'd simply store seconds in a number field, which coincidentally is what happens behind the doors in a database.

The beauty of having it in seconds is that it's once again a single (atomic) fact, without any cultural formatting or localized representation Smile | :)

It's hard to keep things 'simple'.
Bastard Programmer from Hell Suspicious | :suss:
if you can't read my code, try converting it here[^]

AnswerRe: Global Database Design for example to store Addresses Pin
jschell11-Oct-12 10:20
memberjschell11-Oct-12 10:20 
AnswerTHX: Global Database Design for example to store Addresses Pin
LiQuick12-Oct-12 5:21
memberLiQuick12-Oct-12 5:21 
GeneralRe: THX: Global Database Design for example to store Addresses Pin
Eddy Vluggen12-Oct-12 6:37
memberEddy Vluggen12-Oct-12 6:37 
GeneralRe: THX: Global Database Design for example to store Addresses Pin
Jörgen Andersson12-Oct-12 9:15
memberJörgen Andersson12-Oct-12 9:15 
GeneralRe: THX: Global Database Design for example to store Addresses Pin
Eddy Vluggen12-Oct-12 11:54
memberEddy Vluggen12-Oct-12 11:54 
GeneralRe: THX: Global Database Design for example to store Addresses Pin
Jörgen Andersson12-Oct-12 12:34
memberJörgen Andersson12-Oct-12 12:34 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy |
Web01 | 2.8.171207.1 | Last Updated 12 Dec 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid