Lines Matching full:day
1318 ** method returns a Julian Day Number for the current date and time.
2243 ** char *zText = "It's a happy day!";
2258 ** INSERT INTO table1 VALUES('It''s a happy day!')
2265 ** INSERT INTO table1 VALUES('It's a happy day!');
10964 ** SQLite processes all times and dates as Julian Day numbers. The
10974 ** be represented, even though julian day numbers allow a much wider
11017 sqlite3_int64 iJD; /* The julian day number times 86400000 */
11018 int Y, M, D; /* Year, month, and day */
11172 ** Convert from YYYY-MM-DD HH:MM:SS to julian day. We always assume
11267 ** Attempt to parse the given string into a Julian Day Number. Return
11306 ** Compute the Year, Month, and Day from the julian day number.
11332 ** Compute the Hour, Minute, and Seconds from the julian day number.
11450 ** start of day
11490 ** seconds since 1970. Convert to a real julian day number.
11537 ** Move the date backwards to the beginning of the current day,
11556 }else if( strcmp(z,"day")==0 ){
11584 sqlite3_int64 day;
11590 day = tx.iJD/86400000;
11591 tx.iJD -= day*86400000;
11607 if( n==3 && strcmp(z,"day")==0 ){
11698 ** Return the julian day number of the date specified in the arguments
11775 ** %d day of month
11778 ** %j day of year 000-366
11779 ** %J ** Julian day number
11784 ** %w day of week 0-6 sunday==0
11871 int nDay; /* Number of days since 1st day of year */
11995 ** already lost fractional day precision.
21214 ** current time and date as a Julian Day number into *prNow and
21221 day, month, year;
21227 day = (USHORT)dt.day;
21234 now = day - 32076 +
25819 ** current time and date as a Julian Day number into *prNow and
29123 ** current time and date as a Julian Day number into *prNow and
29134 /* Number of 100-nanosecond intervals in a single day */
29138 /* Number of 100-nanosecond intervals in half of a day */
29161 timeF = timeF + ntuPerHalfDay; /* add half a day (from 2305813.5) */
29162 timeW = timeW + (timeF/ntuPerDay); /* add whole day if half day made one */