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