Hello All,
While inserting timestamp(or may be date) in a table, the format I've to stuck to is 'mm/dd/yyyy hh:mm:ss' (or 'mm/dd/yyyy' in case of date field). Is there any other way I can change the format while inserting timestamp in a table? Has local regional settings something to do with this format?
I'd a stored procedure just inserting timestamp data in a table. I passed the data in above mentioned format. It was working fine on few machines but on a particular machine the stored procedure was not working. It just hung. Just with a hit, I changed the local settings, and it worked fine. I tried with other machines as well and found the same behaviuor.
Just wanted to confirm with this behaviour.

Thanx.
Mahesh.


---------------------------------
WIN FREE WORLDWIDE FLIGHTS - nominate a cafe in the Yahoo! Mail Internet Cafe Awards

[Non-text portions of this message have been removed]