SQL Syntax issue

[aguest]

Hi,

I'm loading some data into filemaker and the date field is coming is as text (23 November 2015). During my import routine to move it from a temp table to the correct table I want to convert it to a proper date.

I've used the following code but I'm getting a syntax error in my conversion. I know this is correct syntax for SQL so why doesn't Filemaker recognise it? Any help is greatly appreciated.

TIA

ExecuteSQL ( "
 SELECT LegalForname, LegalSurname, MiddleName
        , PreferredForename, PreferredSurname, UPN
        , ULN, convert(datetime,convert(varchar(30),DateofBirth),103) as DOB, Gender, House, RegistrationDate
        , YearTaughtIn, SIMSAdmissionNo, YearGroup, Ethnicity, Nationality
        , HomeLanguage, FirstLanguage, EligibleforFSM, FSMStartDate
        , FSMEndate, LEACare, PPIndicator, EnrolmentStatus, SENStatus
        , SENStartDate, QuickNote, RegGroup
       
 FROM Loading_StudentDetails";

"|"; "¶" )

[Kris M]

The convert function is not be supported by FM SQL.

FM SQL is a subset of standard SQL.

Google FileMaker 14 SQL Reference

Edited March 4, 2016 by Kris M

[aguest]

Thank you Kris

Edited March 4, 2016 by aguest