Инструменты пользователя

Инструменты сайта


programming:database:mssql:date-convert

Конвертация дат

SELECT
*,
Convert(varchar(10), Dto_apl, 103) AS APLDto_apl,
Convert(varchar(10), Dtx_apl, 103) AS APLDtx_apl,
Convert(varchar(10), Dt_apl_qlt, 103) AS APLDt_apl_qlt,
Convert(varchar(10), Dto_apl, 108) AS APLDto_apl_h,
Convert(varchar(10), Dtx_apl, 108) AS APLDtx_apl_h,
Convert(varchar(10), Dt_apl_qlt, 108) AS APLDt_apl_qlt_h

FROM
APL
WHERE
PKId = $ID
//        //query
//        $sql = "SELECT TOP 1 * FROM [ITservice].[dbo].[v_sd_5555]";
//        $r = mssql_query ( $sql, $cs ) or die ( 'Query Error' );

        // loop the result

//        while ( $row = mssql_fetch_array ( $r ) )
//        {
//            /* do stuff */
//            var_dump($row);
//        }
programming/database/mssql/date-convert.txt · Последнее изменение: 2017/03/27 11:26 — artur

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki