Hi I'm using the console to import data into OrientDB (2.0-M3) that has been exported into a .sql file from MS SQL Server 2008 R2 that contains DateTime fields, which are exported like this:
CAST(0x0000A23C00EE5463 AS DateTime) So the INSERT INTO statement generated by SQL Server is something like: INSERT INTO folders (..., date_create, ...) VALUES (..., CAST(0x0000A23C00EE5463 AS DateTime), ...) When I run "console folders.sql" I get the following error saying "No function with name 'cast' available": Error: com.orientechnologies.orient.core.sql.OCommandSQLParsingException: Error on parsing command at position #0: No function with name 'cast', available names are : [outv,percentile,ifnull,both,last,count,set,traversedvertex,sum,bothv,date,shortestpath,distinct,mode,distance,document,if,gremlin,map,bothe,avg,dijkstra,min,encode,coalesce,max,eval,traversedelement,ine,label,variance,list,format,in,difference,median,decode,unionall,sysdate,intersect,inv,stddev,uuid,traversededge,oute,first,out] The column 'date_create' is defined in SQL Server as 'datetime' and not-null. Do you have any suggestions on how to import DateTime fields into OrientDB from SQL Server? Thanks Ben -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
