Sql

Search

oracle concat datetime

SELECT TO_DATE(TO_CHAR(t.fromdate,'dd-mm-yyyy') ||
               ' ' ||
               TO_CHAR(t.fromtime,'hh24:mi:ss'),'dd-mm-yyyy hh24:mi:ss') as full_date_col 
FROM YourTable t

Comment

PREVIOUS	NEXT

Code Example
Sql :: postgres order by month
Sql :: mysql biginteger size
Sql :: oracle nvl2
Sql :: sqlite show columns
Sql :: insert into auto increment mysql
Sql :: sql sequence
Sql :: how to pass dynamic column name in sql query
Sql :: select true if exists on another table or false sqlserver
Sql :: how to get connect string from mysql database
Sql :: query to find second highest salary
Sql :: oracle default date format
Sql :: how to tun mysql on ubunto
Sql :: convert columns to rows in sql server
Sql :: sql restore backup query
Sql :: oracle group
Sql :: Add colum sqlite table
Sql :: order by multiple columns
Sql :: mysql select or insert current datetime
Sql :: Add new column T-SQL
Sql :: sqlite copy table to another table
Sql :: mysql add hours to time field
Sql :: delete table row in postgresql
Sql :: execut sql python
Sql :: mysql grant user permissions
Sql :: sql mode
Sql :: foreign key on table oracle
Sql :: rebuild index sql server
Sql :: download sql server 2014
Sql :: when matched in sql server
Sql :: postgresql variable in query

Search

SQL

oracle concat datetime

ADD CONTENT