Skip to Main Content

Berkeley DB Family

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

problem simulate timedate for my database

528215Dec 10 2006 — edited Dec 10 2006
Hi
I want to simulate sql table that have fields like this(int id,varchar name,datetime timein)
for simulate this situation I defined database and defined structure like this:

struct TimeDate{
int year;
short month;
short day;
short hour;
short minute;
short second;
};

typedef struct session {
int ID;
char *name;
struct TimeDate Timein;
}SESSION;

is this methood suitable for define datetime or not?
is it good to store unixtime in the database or this method ?

thanks
regards
saeed
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 7 2007
Added on Dec 10 2006
1 comment
949 views