Search
 
SCRIPT & CODE EXAMPLE
 

SQL

how to get yesterday date in sql

SELECT DATEADD(day, -1, CAST(GETDATE() AS date)) AS YesterdayDate;
Comment

PREVIOUS NEXT
Code Example
Sql :: mysql get date difference in hours 
Sql :: Failed to stop mysqld.service: Unit mysqld.service not loaded. 
Sql :: freemysqlhosting keeps deleting tables 
Sql :: sql add column after another 
Sql :: list all indexes postgres 
Sql :: uninstall mysql on ubuntu 
Sql :: sql server find columns list in tables 
Sql :: mysql 3 months ago 
Sql :: alter table add comment oracle 
Sql :: postgresql add enum value 
Sql :: get all tables postgres 
Sql :: install mysql ubuntu 18.04 
Sql :: start mysql server linux terminal 
Sql :: show list of users in mysql 
Sql :: log queries postgre 
Sql :: spark sql concatenate string and int 
Sql :: mysql get last row 
Sql :: psql filed name alter 
Sql :: postgres install unaccent extension 
Sql :: no data found oracle 
Sql :: mysql random limit 1 
Sql :: best configuration for display table in sqlplus 
Sql :: add super privilege mysql 
Sql :: grant schema permissions postgres 
Sql :: sql pick random row 
Sql :: how to add auto increment primary key 
Sql :: postgresql format date dd/mm/yyyy 
Sql :: set statiscis on in ssms 
Sql :: sql command to find foreign key references 
Sql :: create user mysql 
ADD CONTENT
Topic
Content
Source link
Name
5+5 =