ObjectGears Help

           
Forum   ObjectGears (Version: 1.7.1.0)

Other SQL clauses

SELECT clause:

  • CAST(0 AS BIT) AS Escalated
  • CASE WHENt.escalate = 1 then '\ImagesData\all icons\exclamation.png' else '' end AS Escalated
  • '415-' + convert( varchar, t.id) AS FullId
  •  ISNULL( t.[deadline] , CONVERT(Datetime, '9999-012-31 00:00:00', 120)) AS Order_date

Conversion of the date in format date and time to a simple date:

  • CONVERT(DATE, h.date, 101) date

Function returning id of current user:

  • {{ loginuser.id }}

Comment:

  • /*  comment  */
This website is using cookies files to provide services and analyse visits. You agree with that by using this website.     Further information