Author Topic:  sql Query bug  (Read 484 times)

Michael co

  • EA User
  • **
  • Posts: 60
  • Karma: +0/-0
    • View Profile
 sql Query bug
« 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..

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 7752
  • Karma: +165/-21
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re:   sql Query bug
« Reply #1 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

Michael co

  • EA User
  • **
  • Posts: 60
  • Karma: +0/-0
    • View Profile
Re:   sql Query bug
« Reply #2 on: September 20, 2013, 08:51:01 pm »
yes It does not work
I have tested it ,,

tx