Forum Replies Created

Viewing 5 posts - 16 through 20 (of 20 total)

  • RE: SQL Query to find minimum of date

    Thank you FLo and Ramesh!

    Ramesh your code works beautifully. But you'll have to bear with a new user : ME. You have created a table with the selected inputs and...

  • RE: SQL Query to find minimum of date

    Ramesh,

    This is an invalid condition in the current context. In case sl_no is same, it will have similar description.

    So the valid input data would be

    either

    401 4/10/2009 23:00...

  • RE: SQL Query to find minimum of date

    Hi Ramesh

    This should be the output (Please note that teh data is stored in UNIX format i.e int data type :

    sl_noinitial_datelog_timedescription

    2454/9/2009 13:00 ...

  • RE: SQL Query to find minimum of date

    My apologies everyone!

    The data is stored in this format

    sl_noinitial_datelog_timedescription

    24512392820001239292260This is a description

    24512392820001239291900This is a description

    24512392820001239291480This is a description

    29612394044001239404820This is a description

    29612394044001239404940This is a description

    29612394044001239405060This is a description

    29612394044001239405420This is a...

  • RE: SQL Query to find minimum of date

    Hi FLO, the major problem is that the time is stored in UNIX /EPOCH FORMAT (Integer value) and I would want the output and date inputs in normal TIME DATE...

Viewing 5 posts - 16 through 20 (of 20 total)