RE: [PHP-WIN] date format problem with mssql_* functions

convert(varchar, @date, <date format accoring to the manual>) <date format accoring to the manual> :== Without century (yy) With century (yyyy) Standard Input/Output** - 0 or 100 (*) Default mon dd yyyy hh:miAM (or PM) 1 101 USA mm/dd/yy 2 102 ANSI yy.mm.dd 3 103 British/French dd/mm/yy 4 104 German dd.mm.yy 5 105 Italian dd-mm-yy 6 106 - dd mon yy 7 107 - mon dd, yy 8 108 - hh:mm:ss - 9 or 109 (*) Default + milliseconds mon dd yyyy hh:mi:ss:mmmAM (or PM) 10 110 USA mm-dd-yy 11 111 JAPAN yy/mm/dd 12 112 ISO yymmdd - 13 or 113 (*) Europe default + milliseconds dd mon yyyy hh:mm:ss:mmm(24h) 14 114 - hh:mi:ss:mmm(24h) - 20 or 120 (*) ODBC canonical yyyy-mm-dd hh:mi:ss(24h) - 21 or 121 (*) ODBC canonical (with milliseconds) yyyy-mm-dd hh:mi:ss.mmm(24h) * The default values (style 0 or 100, 9 or 109, 13 or 113, 20 or 120, and 21 or 121) always return the century (yyyy).** Input when converting to datetime; Output when converting to character data. -----Original Message----- From: Peter Misun To: Darvin Andrioli Cc: php-windows@lists.php.net Sent: 5/12/03 2:48 PM Subject: [PHP-WIN] date format problem with mssql_* functions ya, it's ok - I was too blind to see, that connection was OK (cause of many errors in subsequent functions early working with odbc style) but now I got real problem - the format of date values is really strange (if getting with mssql_fetch_row) and I don't know, where I can set date format for getting (and setting) data with mssql_* functions (with odbc it was ok, format was pure and clear) 5o Darvin Andrioli wrote: > Peter wrote: > > > gyus, it's nice, but I asked about MSSQL - not MySQL > > > > anybodey can help with that damn 'interface' file? > > > Well I read the manual page related to mysql_connect and some user comments, > according to that comments seems that the interface file is related to the > sysbase driver used on *nix box. > > I run mssql_connect without any problem on Windows 98/2000. I enabled the > extension php_mssql.dll, and I put the network name of my server as > 'servername' in mssql_connect. > > Darvin -- Mgr. Peter Misun MicroStep-MIS, Ilkovicova 3, 841 04 Bratislava, Slovakia tel: +421/ 2/ 602 00 127, 111, fax: +421/ 2/ 602 00 180 -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php