Loading

get year,month,day,hour...

kobycool68

hello i have database which contain table with 'Date' column. (e.g. 17/5/2004 12:00 AM) 1) i`m interesting to get separately the year, month, day and hour. there is any method for that? 2) and finally i want to put every separate catagory in separate column(in new table). in which type of data should be year, month, hour...? thanks koby

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Adam Erstelle22y ago
1) There are functions of the Date object that will return what you ask for. You may have to read up a bit more on them to get the specifics. 2) Not sure why you want to save the information in seperate tables, as it is not very good design, however, the best data type would be the smallest number that you can save in your DB, 4 digits for year, 2 digits for the rest.
0