Sparx Systems Forum

Discussion => General Board => Topic started by: Michael co on September 18, 2013, 09:12:21 pm

Title:  sql Query bug
Post by: Michael co on September 18, 2013, 09:12:21 pm
the following SQL does not work

  SELECT 'b'+version  as version_no
                              FROM  t_document  WHERE  DocType  = 'Baseline'
                               and   CDate(docdate)  <  CDate('9/18/2013 1:09:01 PM')

thus how can I deal with datetime conversions ?

Thank you..
Title: Re:   sql Query bug
Post by: Geert Bellekens on September 18, 2013, 09:53:12 pm
That depends on which database you have your repository.
make sure your query works on the database directly before trying it in EA.

Geert
Title: Re:   sql Query bug
Post by: Michael co on September 20, 2013, 08:51:01 pm
yes It does not work
I have tested it ,,

tx