|
Home
Articles
|
|
|
|
On August 19th, 2009 06:53 a visitor came here looking for "remove timestamp on polaroid i735" and that person was viewing the following page:
Fujifilm Finepix A800 8MP Digital Camera with 3x Optical Zoom
Almost perfect This is my second Fuji digital. My first one had a view finder. This one does not. I dont think anyone should buy a camera that doesnt have a view ...
|
|
Questions & Answers Powered by Yahoo! Answers
Question : How can I remove date and time stamp from my digital pictures
I use a Nikon Coolpiz s550 and put on the date and timestamp when looking at all the settings and forgot to turn it off. Is there any way to remove it from the pictures I already took on my camera Simply turning off the setting didn't remove it from the pictures I already took. If not, what's the easiest way to do it using photoshop or a simpler graphics program
Answer:
Use the photo stamp remover toolhttp://www.softorbits.com/photo-stamp-remover/
|
Question : How can I remove the milliseconds from my SQL data
I am using a method that inserts the CURRENT_TIMESTAMP into a database. I notice that it is putting in milliseconds. This is messing with my data. However, I do notice that if I edit the time so there is not milliseconds or the time shows 000, I am able to call the info as I need.What can I do to remove the milliseconds from my data when I am doing an insertExample:This does NOT return any results2007-06-15 16:51:17.027This does return results2007-06-15 16:51:17.000
Answer:
You can remove milliseconds by as following:select cast(cast('2007-06-15 16:51:17.027'as varchar(19)) as datetime)You can update all your data with Update stament:UPDATE tab_nameset time_col=cast(cast(time_col as varchar(19)) as datetime)
|
|
|