Skip to content

query.cfc exception when using time mask #4

@atuttle

Description

@atuttle

... thinks it's a bound parameter:

select 
            sessionId
            , title
            , descr
            , byline
            , location
            , startTime
            , endTime
            , sortVal
            , (SELECT CONVERT(VARCHAR(11), startTime, 106) AS [DD MON YYYY]) as datepart
            , (SELECT CONVERT(VARCHAR(11), endTime, 108) AS [hh:mi]) as timepart
        from tblSession
        order by startTime, sortVal

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions