I have a requirement which goes like this:
My timestamp(6) field, which is, say,
Now, if I wanted to change this to the previous days value, still retaining the hour, minute, second and millisecond values as it is, how would I do that? What I mean is, if I had to get
2014-10-07 10:14:51.210000 from
2014-10-08 10:14:51.210000, how can that be done in an efficient way?