|
|
Choosing A Webhost: |
TIMESTAMP/DATE Format & INSERT: msg#00259db.maxdb
I am porting a database from Access to MaxDB. From the Access-DB I have made a SQL-Dump that contains about 800 dates with a date in it. The date-format in the dump-fil is "DD.MM.YYYY HH:MM:SS". I am now trying to insert these lines into the MaxDB-DB by using the SQL-Studio. For example the following codes demonstrates what I am trying to do: CREATE TABLE aaa ( id FIXED(10) DEFAULT SERIAL, sent TIMESTAMP, PRIMARY KEY (id)) // INSERT INTO aaa (sent) VALUES ('31.03.2005 13:35:21') ... Unfourtunately this does not work. I think that one point is a wrong date-format that should YYYY-MM-DD because of the ISO-mode. From the manual I do not understand, where I can change the ISO-mode to an other that meets my requirements. I would be happy if anyone can help me - thanks! -- Sparen beginnt mit GMX DSL: http://www.gmx.net/de/go/dsl -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx
|
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | AW: Loadercli "Unexpected token" - Re: Loadercli, Schildberg, Steffen |
|---|---|
| Next by Date: | RE: TIMESTAMP/DATE Format & INSERT, Kevin Wilson |
| Previous by Thread: | AW: Loadercli "Unexpected token" - Re: Loadercli, Schildberg, Steffen |
| Next by Thread: | RE: TIMESTAMP/DATE Format & INSERT, Kevin Wilson |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
Free MagazinesCisco NewsReceive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business. subscribe Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field. subscribe The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business. subscribe Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company. subscribe Total Telecom Total Telecom is "The Economist of the communications industry". subscribe |
Home
| advertise | OSDir is
an inevitable website.
|