SqlDbx Forum

samspritzer

Member

Copy and paste doesn't work correctly

SQL Server 2008 R2
SQLdbx 4.10.1 Personal

I have a column that has a datetime value.  If I enter 4/30/2015, it accepts it as 4/30/2015 12:00:00PM.  Previous versions used AM instead.  And if I copy a datetime value with AM, the pasted value changes it to PM.
Thanks!

sqldbxhelp

Administrator

Re: Copy and paste doesn't work correctly

Not sure how you do it. Enter 4/30/2015 where?
What you mean copy datetetime with AM?

samspritzer

Member

Re: Copy and paste doesn't work correctly

I am sorry I was not more thorough....

If you select all records from a table then right click on the Results pane and modify data, enter the changes there.   Use a table that has a datetime field.  Modify one of the cells as 5/1/2015 or any date you prefer.  This will display as 5/01/2015 12:00:00 AM.  Now copy that to another row.  Notice the AM becomes PM. 

Hope this helps.
Sam

samspritzer

Member

Re: Copy and paste doesn't work correctly

Thank you for fixing this.