SQL date format conversion from INT(yyyymmdd) type to date(mm/dd/yyyy)

sql date-formatting date-conversion
user2963607 picture user2963607 · Nov 7, 2013 · Viewed 74.5k times · Source

I have a table with datekey column values(20120728,20120728...) in format of yyyymmdd as int type, I need to make them into date format of mm/dd/yyyy while writing select statement.

Answer

vhadalgi picture vhadalgi · Nov 7, 2013 
DECLARE @date int;
SET @date = 20131107

SELECT CONVERT(date, CONVERT(varchar(8), @date), 112)

Related questions

How to insert date values into table

How can I insert into table with different input using / ,with date datatype? insert into run(id,name,dob)values(&id,'&name',[what should I write here?]); I'm using oracle 10g.

Read More
Convert timestamp to date in MySQL query

I want to convert a timestamp in MySQL to a date. I would like to format the user.registration field into the text file as a yyyy-mm-dd. Here is my SQL: $sql = requestSQL("SELECT user.email, info.name, FROM_UNIXTIME(…

Read More
ORA-01810: format code appears twice

Why is the sql below generating an ORA-01810 error? I researched the error and I am using different date formats for each date insert INSERT INTO bag_grte_clm ( schd_dprt_ldt, arr_trpn_stn_cd, bkg_crtn_gdt, sbmt_…

Read More