Wednesday, 26 July 2023

DATE SERIES - POSTGRESQL

 SELECT dates::date FROM generate_series(CURRENT_DATE,   CURRENT_DATE-4, '-1 day'::interval)dates


at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Kiro - Core Features

What is Kiro Kiro is an innovative AI-powered IDE that revolutionizes software development through intelligent assistance and structured wor...

  • CACHING in Snowflake
    Result Cache Stores the results of a query (Cloud Services) Same queries can use that cache in the future Table data has not changed Micro-p...
  • List
    #Sample   thislist = [ "apple" , "banana" , "cherry" ] print ( "MyList : " , thislist ) ​ thislist...
  • Create Index
     CREATE INDEX sync_idx_abc ON schemaname.tablename(columnname);