Discussions

Expand all | Collapse all

User defined Date Format for Select query

  • 1.  User defined Date Format for Select query

    Posted 08-21-2019 04:51
    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 08-21-2019 06:01
    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.