imroza
Posts: 21
|
| Posted: 07/14/2009, 9:58 AM |
|
I Have this setting:
-------------------------
/Connection Settings @0-31D2B6FF
$CCConnectionSettings = array (
"Lurto" => array(
"Type" => "MSSQLServer",
"DBLib" => "ODBC",
"Database" => "DBListaTx",
"Host" => "localhost",
"Port" => "",
"User" => "******",
"Password" => "******",
"UseODBCCursor" => "",
"Persistent" => false,
"DateFormat" => array("yyyy", "-", "mm", "-", "dd", " ", "HH", ":", "nn", ":", "ss"),
"BooleanFormat" => array(1, 0, ""),
"Uppercase" => false
),
"InternetDB" => array(
"Type" => "MySQL",
"DBLib" => "MySQL",
"Database" => "lurto_db",
"Host" => "localhost",
"Port" => "",
"User" => "******",
"Password" => "******",
"Persistent" => false,
"DateFormat" => array("yyyy", "-", "mm", "-", "dd", " ", "HH", ":", "nn", ":", "ss"),
"BooleanFormat" => array(1, 0, ""),
"Uppercase" => false
)
);
//End Connection Settings
-------------------------
I'm having trouble with datetime formats. I can't find a way to display any date from my MSSQLServer connection.
Can anybody guide me?
|
 |
 |
damian
Posts: 838
|
| Posted: 07/14/2009, 4:20 PM |
|
please try this link:
http://forums.codecharge.com/posts.php?post_id=106970&s_keyword=mssql
_________________
if you found this post useful take the time to help someone else.... :)
|
|
|
|
imroza
Posts: 21
|
| Posted: 07/14/2009, 10:55 PM |
|
Thanks Damian.
Solution:
server date format settings:
yyyy-mm-dd HH:nn:ss.S
------------------------------
"DateFormat" => array("yyyy", "-", "mm", "-", "dd", " ", "HH", ":", "nn", ":", "ss", ".", "S"),
------------------------------
Rob
|
|
|
|
|
