Re: MS-SQL date format problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Are you using the FreeTDS version of the mssql ext? Because this option
is only available for the DB-Library version. According to FreeTDS docs,
it can be changed by the locale setting, but this may not be applicable
for the sybase/mssql ext.

-- bob

On Mon, 12 May 2003, Peter Misun wrote:

>
> I try to set mssql.datetimeconvert to 0 in php.ini , also with ini_set function, but the result was the same (not "2003-06-01 13:05:11", but that useless format)
> why?
>
>
> Robert Twitty wrote:
>
> > The default character format chosen for datetime fields is determined by
> > the underlying driver. For ODBC its "2003-06-01 13:05:11.234" and for
> > DB-Library and FreeTDS it's "Jun 1 2003 1:05PM". If you set the ini option
> > mssql.datetimeconvert to 0, then it will be "2003-06-01 13:05:11". On
> > FreeTDS it may also be influenced by the locale setting. It does
> > not matter whether you use mssql_fetch_array or mssql_fetch_row.  If you
> > want to be certain that your datetime data will always appear a certain
> > way then use CONVERT, instead of relying on the driver.
> >
> > -- bob
> >
> > On 12 May 2003, Adam Voigt wrote:
> >
> > > Hmm, what fieldtype is it in the DB?
> > > We have a bunch of DATETIME type's, and using
> > > a standard query it works just fine, returning
> > > in the proper format, without ODBC.
> > >
> > > The only difference is we use mssql_fetch_array
> > > instead of fetch_row.
> > >
> > > On Mon, 2003-05-12 at 09:12, Peter Misun wrote:
> > > > Does anybody know, how to set date-time format for mssql_* functions?
> > > >
> > > > For example, after retrieving data by function mssql_fetch_row, the value returned was "22 XII 1975 0:00
> > > > "  (which is midnight of 22nd December 1975)
> > > > As you see, value "XII" (for month) is really unusable
> > > >
> > > > where to set that date format?
> > > >
> > > > with odbc functions it returns "1975-12-22 00:00:00.000", wha is really clear
> > > >
> > > > 5o
> > > --
> > > Adam Voigt (adam@cryptocomm.com)
> > > Linux/Unix Network Administrator
> > > The Cryptocomm Group
> > >
> > >
> > > --
> > > PHP Database Mailing List (http://www.php.net/)
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> > >
> > >
>
> --
>
> 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 Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux