Sql

declare @thirtydaysago datetime
declare @now datetime
set @now = getdate()
set @thirtydaysago = dateadd(day,-30,@now)

select @now, @thirtydaysago

PREVIOUS	NEXT

Code Example
Sql :: select only the month-day from date in PL-SQL
Sql :: using SQL in rails migration
Sql :: sqlite select split string
Sql :: postgresql concat string with separator
Sql :: mysql changer nom table
Sql :: sqlalchemy bulk delete
Sql :: oracle chain rules
Sql :: postgresql database url
Sql :: mysql GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Sql :: truncate table sqlite
Sql :: unique in sql server
Sql :: postgresql could not start server mac
Sql :: update set table column to null
Sql :: sql statement to change a field value
Sql :: on update current_timestamp jpa
Sql :: delete table cassandra
Sql :: postgresql create table many-to-many
Sql :: create unique constraint postgres
Sql :: An error occurred while installing mysql (2.9.1), and Bundler cannot continue
Sql :: how to open mysql in docker
Sql :: mysql decimal remove trailing zeros
Sql :: how to recreate postgres database in docker
Sql :: sql select
Sql :: multiple row primary key
Sql :: insert data from one database table to another database table in postgresql using pgadmin
Sql :: missing left parenthesis error in sql
Sql :: oracle step procedure
Sql :: php mysql select current month
Sql :: mysql bind-address default value
Sql :: cara menampilkan user di mysql terminal