Home Forums SQL Server 2005 SQL Server 2005 Integration Services convert datatype DT_STRING to DT_DBDATE in ssis RE: convert datatype DT_STRING to DT_DBDATE in ssis

  • June 12, 2013 at 12:06 pm

    #1623461

    SELECT CONVERT(VARCHAR(10),GETDATE(),121);

    Output: 2013-06-12

    Example:-

    SELECT CONVERT(VARCHAR(10),ContractEndDate,121)

    From TestDataTable_Archive;

    You can Play with the different format values like 111 etc.

    SELECT CONVERT(VARCHAR(10),GETDATE(),111);

    Output: 2013/09/30