Thread: Search/Replace from Title Field to Pubdate
View Single Post
Old 08-05-2012, 10:27 AM   #3
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 29,778
Karma: 54830978
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Peeking into the DB

pubdate is shown as (Type: TIMESTAMP)
Code:
2005-02-24 07:00:00
or
2005-02-24 07:00:00+00:00
I don't see the space between the date and time.
Yuo might place a literal time value in the replace eg 01:00+00:00
theducks is offline   Reply With Quote