My Blog

Category: Date & Time

  • Waarom is blackjack een van de meest populaire casinospellen?

    —

    by

    Yousaf Saleem
    in

    Er zijn verschillende redenen waarom een populair kaartspel wereldwijd veel spelers aantrekt. Een van de belangrijkste eigenschappen is de eenvoud van de regels, waardoor zowel beginners als ervaren spelers zich snel thuis voelen. Dit maakt het spel toegankelijk voor iedereen, ongeacht hun eerdere ervaring met kansspelen. Bovendien hebben strategieëen een grote invloed op het succes…

  • time Function

    —

    by

    Awais Khan
    in

    SQLite time function is used to calculate time and return time in ‘HH-MM-SS’ format. Syntax: Here, timestring is a date value which can be anyone of the following: Index timestring Description 1) now It is a literal used to return the current date. 2) YYYY-MM-DD It specifies the date value formatted as ‘YYYY-MM-DD’ 3) YYYY-MM-DD HH:MM It…

  • strftime Function

    —

    by

    Awais Khan
    in

    The SQLite strftime function is a very powerful function which facilitates you to fetch date and time and also perform date calculation. Syntax: Here, format can be any of the following: Index format Explanation 1) %Y Year as 4 digits (0000 to 9999) 2) %W Week of year (00 to 53) 3) %w Day of week (0…

  • now Function

    —

    by

    Awais Khan
    in

    SQLite “now” is not actually a fuction, but “now” is a timestring parameter that is used in various SQLite functions to fetch the current date and time. Syntax: There are three types of syntax for now function in SQLite: Or Or The third syntax is used when expressing the current date/time using the strftime function.…

  • Julianday Function

    —

    by

    Awais Khan
    in

    The SQLite julianday function facilitates you to apply modifiers and then returns the date as a Julian Day after taking the date as an input. A Julian Day is the number of days since Nov 24, 4714 BC 12:00pm Greenwich time in the Gregorian calendar. The julianday function returns the date as a floating point…

  • datetime Function

    —

    by

    Awais Khan
    in

    The SQLite datetime function is used to retrieve date and time in different format. The result format of datetime function is ‘YYYY-MM-DD HH:MM:SS’. Syntax: Example1: Retrieve current date and time: Output: Example2: Add/ subtract years to current date and time: Output: Example3: Add/ subtract days to current date and time: Output: Example4: Add/ subtract hours…

  • Date Function

    —

    by

    Awais Khan
    in

    The SQLite “DATE” function is used to retrieve the date and return it in ‘YYYY-MM-DD’ format. Syntax: Here, timestring is a date value which can be anyone of the following: Index timestring Description 1) now It is a literal used to return the current date. 2) YYYY-MM-DD It specifies the date value formatted as ‘YYYY-MM-DD’ 3) YYYY-MM-DD…

  • Date and Time() Functions

    —

    by

    Awais Khan
    in

    In SQLite, date and time() functions are used to retrieve current date and time. The date and time functions use a subset of IS0-8601 date and time formats. There are 6 different date and time functions which return and do calculation on date and time in different formats: Index Functions Description 1) SQLite date() function…