How to convert a string to date using OLEDB function?

Question

Is there any function similar to OCIDateFromText()?

I have to read the date from a text file and store it in the sql database in a date column.

Please suggest how to do it?

Thanks in Advance.

---

Answer 1

First import the text file using OPENROWSET as,

INSERT INTO myTable(FileName, FileType, Document)
   SELECT 'Text1.txt' AS FileName,
      '.txt' AS FileType,
      * FROM OPENROWSET(BULK N'C:\Text1.txt', SINGLE_BLOB) AS Document;

Refer http://technet.microsoft.com/en-us/library/ms190312.aspx

Then you can use either CONVERT or CAST function in TSQL to convert the string column to date time format.

Refer http://msdn.microsoft.com/en-us/library/ms187928.aspx

http://stackoverflow.com/questions/17301268/sql-convert-string-to-date-format-112

---

Regards, RSingh

Answer 2

Double post: http://social.msdn.microsoft.com/Forums/en-US/6ac7ea48-77d2-40e5-ab40-fb0bf9ce6799/how-to-convert-a-string-to-date-using-oledb-function?forum=transactsql

---

Olaf Helper

[ Blog] [ Xing] [ MVP]