![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
![]() |
Mon, Jun 2 2014 12:05 AM | Permanent Link |
Martin Pflug | Hello,
i have a DateTime as string ('06.11.2004 16:29:18') and search for an sql-statement to insert it into my table. I thought it must lool like: insert into mytable(FieldString1, FieldString2, FieldTimestamp) values ('StringNr1', 'StringNr2', '06.11.2004 16:29:18') It doesn't work. I tried to find out what is the right syntax and read in the manuel and also in this forum. My english isn't very well but i found something like that: insert into mytable(FieldString1, FieldString2, FieldTimestamp) values ( 'StringNr1', 'StringNr2', CAST('06.11.2004 16:29:18')AS TIMESTAMP) It also doesn't work. Please give me a help. Thank you |
Mon, Jun 2 2014 3:46 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Martin
>i have a DateTime as string ('06.11.2004 16:29:18') and search for an sql-statement to insert it into my table. > >I thought it must lool like: > >insert into mytable(FieldString1, FieldString2, FieldTimestamp) >values ('StringNr1', 'StringNr2', '06.11.2004 16:29:18') You have two problems: In ElevateDB the datetime string should be 2004-11-06 16:29:18 (the date portion is in sql format) Secondly if you supply it as a string then you must preface it with the keyword TIMESTAMP so your statement would become insert into mytable(FieldString1, FieldString2, FieldTimestamp) values ('StringNr1', 'StringNr2', TIMESTAMP '2004-22-06 16:29:18') There are some helpers built into the engine eg DateTimeToSQLStr so you can call those to get the correctly formatted string to pass to the INSERT command. Alternatively you can use string sliceing to build the right command eg insert into mytable(FieldString1, FieldString2, FieldTimestamp) values ('StringNr1', 'StringNr2', TIMESTAMP SUBSTR('06.11.2004 16:29:18',7,4)+'-'+SUBSTR('06.11.2004 16:29:18',4,2)+'-'+SUBSTR('06.11.2004 16:29:18',1,2)+' '+SUBSTR('06.11.2004 16:29:18',,11,8)) I think I got the string positions right but its untested. Roy Lambert |
Mon, Jun 2 2014 1:13 PM | Permanent Link |
Martin Pflug | That's it.
Thank you |
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |