Search
 
SCRIPT & CODE EXAMPLE
 

SQL

spark sql concatenate string and int

select concat('01/01/', extract(year from current_timestamp()) - 5)
select concat('01/01/', 2020)
Comment

PREVIOUS NEXT
Code Example
Sql :: get table columns from sql 
Sql :: sql query to make a existing column auto increment 
Sql :: Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1 
Sql :: mysql show indexes on table 
Sql :: sql last row in table 
Sql :: oracle search source code 
Sql :: rename table sql 
Sql :: VERIFY INDEXES IN SQL ORACLE 
Sql :: created at and updated at in mysql 
Sql :: mysql where one year ago 
Sql :: postgres stop server mac 
Sql :: oracle last character of string 
Sql :: mysql import ignore errors 
Sql :: oracle first and last day of previous month 
Sql :: postgresql convert text to float 
Sql :: mysql text type max length 
Sql :: oracle to date 
Sql :: import sql file laravel cmd 
Sql :: The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement 
Sql :: String concatenation in PostgreSQL 
Sql :: sql find missing values between two tables 
Sql :: mssql remove column 
Sql :: sql throw error 
Sql :: liquibase update row 
Sql :: mysql subtract month from timestamp 
Sql :: oracle check numeric 
Sql :: install mysql in amazon linux 2 
Sql :: import sql file in mysql 
Sql :: split first name and last name in sql 
Sql :: ALL_TAB_PARTITIONS 
ADD CONTENT
Topic
Content
Source link
Name
2+3 =