Discussions

Expand all | Collapse all

User defined Date Format for Select query

  • 1.  User defined Date Format for Select query

    Posted 29 days ago
    Hi,

    Please let us know is it possible to fetch the Date output in any specific format if the data is stored  under DATE OR TIMESTAMP Datatype.

    for example: dd/mm/yyyy hh24:mi:ss or dd-mon-yyyy or any other format.
    #Core


  • 2.  RE: User defined Date Format for Select query

    Posted 29 days ago
    Hi,

    I guess you are asking if you can format dates in omnisql.
    Sadly it's not possible to format dates, timestamps or other types in the tool, because the format is embedded in the code of the tool.
    If you want to format data types you have to use external tools.