I have two fields one being timestamp and another being the date in timestamp ( GetasDate(timestamp))
but I am getting some random values in 6 digits for the date field.
How do I fix that. Probably it would me a mistake somewhere. Let me know where to look at.