MSSQL get current date query && with different time zone && get one day less && get column names && get database

SELECT [Title], [Firstname], [Surname], [Company_name], [Interest]
FROM [dbo].[EXTRANET]
WHERE day(Submission_date)=day(now) and
     month(Submission_date)=month(now)
     and year(Submission_date)=year(now)


https://stackoverflow.com/questions/11955281/sql-where-datetime-column-equals-todays-date


// In case of different timezone get time with left join

SELECT table1.time AT TIME ZONE 'UTC' AT TIME ZONE 'Pacific Standard Time' as TriageEndTime
        FROM table1 LEFT JOIN table2 ON table1.id = table2.Id
        AND DAY(table1.CreatedTime AT TIME ZONE 'UTC' AT TIME ZONE 'Pacific Standard Time') = DAY(CAST(GETDATE() AS DATETIME) AT TIME ZONE 'Pacific Standard Time')
        AND MONTH(table1.CreatedTime AT TIME ZONE 'UTC' AT TIME ZONE 'Pacific Standard Time') = MONTH(CAST(GETDATE() AS DATETIME) AT TIME ZONE 'Pacific Standard Time')
        AND YEAR(table1.CreatedTime AT TIME ZONE 'UTC' AT TIME ZONE 'Pacific Standard Time') = YEAR(CAST(GETDATE() AS DATETIME) AT TIME ZONE 'Pacific Standard Time')


https://stackoverflow.com/questions/11955281/sql-where-datetime-column-equals-todays-date
https://www.w3schools.com/sql/sql_join_left.asp


// 1 day prior
        SELECT *
        FROM table1 LEFT JOIN table2 ON table1.id = table2.id
        AND DAY(table1.CreatedTime AT TIME ZONE 'UTC' AT TIME ZONE 'Pacific Standard Time') = DAY(DATEADD(DAY, -1, CAST(GETDATE() AS DATETIME) AT TIME ZONE 'Pacific Standard Time'))
        AND MONTH(table1.CreatedTime AT TIME ZONE 'UTC' AT TIME ZONE 'Pacific Standard Time') = MONTH(DATEADD(DAY, -1, CAST(GETDATE() AS DATETIME) AT TIME ZONE 'Pacific Standard Time'))
        AND YEAR(table1.CreatedTime AT TIME ZONE 'UTC' AT TIME ZONE 'Pacific Standard Time') = YEAR(DATEADD(DAY, -1, CAST(GETDATE() AS DATETIME) AT TIME ZONE 'Pacific Standard Time'))

// get db
SELECT name FROM master.sys.databases
https://stackoverflow.com/questions/147659/get-list-of-databases-from-sql-server
// Get column names
 SELECT COLUMN_NAME  FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = N'table'

// get table names
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG='dbName'

https://stackoverflow.com/questions/3913620/get-all-table-names-of-a-particular-database-by-sql-query