Requirements Requirements appear in the week, how do

Data sheet needs to deal with the week, how design

Tim is one week in the table field

After a week or calculate where to get the date?<-! Main posts under Banner (D4) -><-! Posts under the main text (D5) ->
Reply:
This is not necessary to increase the field, the proposal directly calculated weeks.
Reply:
Of course, is to get the time and then forget it. . . Redundant information can get swollen database ~ ~
Reply:

cited a floor birdsaction reply:

no need to increase this field, we recommend directly calculated weeks.

I was thinking,
But how the query from the database according to the cycle?
Reply:
Insert data into the database, there is no date in this field, is inserted into the data processing time? Do not quite understand your specific processes.
Reply:

references, 4th Floor birdsaction reply:

database insert data, there is no date in this field, is inserted into the data processing time? Do not quite understand your specific processes.

There are date fields is long type.

Today this week have the current month by the current data in the query, you do not build these fields in the table, do not build, how to check ah
Reply:
The long time to convert what you want to get a date, day of week
Reply:

references, 5th Floor knxw0001 reply:

Quote: references to the 4th floor birdsaction reply:

Insert data into the database, there is no date in this field, is inserted into the data processing time? Do not quite understand your specific processes.

There are date fields is long type.

Today this week have the current month by the current data in the query, you do not build these fields in the table, do not build, how to check ah

You would not dare put time into long in the database to check ah?
Today is the two markers 0:00 to 24 points Mody, turn into a long investigation is not finished in the database. . . .
Reply:

references, 5th Floor knxw0001 reply:

Quote: references to the 4th floor birdsaction reply:

Insert data into the database, there is no date in this field, is inserted into the data processing time? Do not quite understand your specific processes.

There are date fields is long type.

Today this week have the current month by the current data in the query, you do not build these fields in the table, do not build, how to check ah

just need a date field is enough these needs can query The date and time functions to achieve
Reply:
Simpledateformat came out