RE: inputting datetime to mssql

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

 



Henrik,

It's possible that the database is interpreting your date as a couple of
subtraction operations.  I always use quotes or single ticks around my
dates when refrencing them in SQL.

Example:

INSERT into some_table (date) values ("2003-07-25");

Give a sample of your code so that your problem can be narrowed down.

Ryan

-----Original Message-----
From: Henrik Hornemann [mailto:HEH@DNLB.DK] 
Sent: Friday, July 25, 2003 9:18 AM
To: php-db@lists.php.net
Subject:  inputting datetime to mssql


Hi,

I had this problem that was driving me crazy. I was trying to input a
datetime to a mssql table, formated the same way as I use in all my
other tables i.e d-m-Y. But no matter which variations of the basic
format I tried, it didn't understand the date correctly. In desperation
I tried something stupid, inverting the format to Y-m-d, which actually
worked. My question is, how can this be possible that datetime fields in
two tables in the same datebase requires the input date to be formated
in different ways?? And is there any way to fix the odd one out?

Regards Henrik Hornemann

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



-- 
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