도쿄사는 외노자

출처 : http://www.w3schools.com/sql/func_convert.asp SyntaxCONVERT(data_type(length),expression,style) ValueDescriptiondata_type(length)Specifies the target data type (with an optional length)expressionSpecifies the value to be convertedstyleSpecifies the output format for the date/time (see table below) 사용예更新日 between CONVERT(VARCHAR,DATEADD(year, -1, GetDate()),112) AND CONVERT(VARCHAR,GetDate()..

1. DB Link? 로컬 DB에서 Database Link 생성을 통해, 원격지 DB의 데이터를 가져올 수 있음.# DB링크의 설정을 위해서는 DBA 권한이 필요하다. 2. DB LINK 설정 1) CREATE DATABASE LINK CREATE DATABASE LINKDB LINK명CONNECT TO유저명IDENTIFIED BY비밀번호USING'(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 호스트명)(PORT = 1521)))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = 서비스명)))'; CREATE DATABASE LINKDBLK_ENRAICONNECT TOENRAIIDENTIFIED B..

ORACLE - VARCHAR-> DATETO_DATE( String값, 'yyyymmdd') ex) TO_DATE( '20120704', 'yyyymmdd') - DATE -> VARCHAR TO_CHAR(DATE필드, 'yyyymmdd') ex) TO_CHAR( REG_DATE, 'yyyymmdd') MSSQL - VARCHAR -> DATETIMECONVERT( DATETIME,String값) ex) CONVERT( DATETIME, '20120704') - DATETIME -> VARCHAR CONVERT (VARCHAR , DATETIME필드, 112) ex) CONVERT( VARCHAR, REG_DATE, 112 ) 출처:DATE/VARCHAR 변환 (oracle vs mssql)

Oracle / Tibero TO_NUMBER('10') Mssql CONVERT(NUMERIC, '10') Informix TO_NUMBER('10') Sybase CAST('10' AS INT) MySQL CAST('10' AS UNSIGNED) DB2 CAST('10' AS INTEGER) 출처 : http://extremeblue.tistory.com/35