• Apologies for being late ,

    my requirement is i am taking min of snapshot date from one of my table .

    for ex :

    select Min (Snapshot_date) from table.

    Suppose output will be like 'Dec 30, 2015 12:07:48.0 AM'

    but i would like to convert the output to 'Dec 30, 2015 12:00:00.0 AM'

    Please do let me know how to convert it .

    Best Regards,

    Abhi