Hi all,
I am building a site on a Unix-based server which needs to pull data from a query on an external MS SQL database. I can make the connection, pull most fields, etc. with no difficulty. I had some trouble with one date field, but was able to overcome that.
However, I am stuck now on one field- it's a start time for an event. This one field (on the MSSQL side) is a varchar that is obtained by using the substring command to extract just the time from a field in the table (from a datetime field for non-recurring events and from an integer field for recurring events).
When I try to simply pull it in as varchar, I don't get any errors, but no data displays. When I convert to datetime, it's setting them all either to the current time or the default Unix time.
Any suggestions on how to handle this?
Thanks in advance for any help.
