February 10, 2012, 17:49:21 *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Please support SEO4smf further development donating here or use paypal button from left menu.
 
  Home   Forum   Help Search Directory Calendar Login Register    RSS 2.0 feedAtom feed


News
Please support SEO4smf further development donating here or use paypal button from left menu.
Pages: [1]
  Print  
Author Topic:

The string was not recognized as a valid DateTime. There is a unknown word start

 (Read 2650 times)
0 Members and 1 Guest are viewing this topic.
christ.bandi
Jr. Member
**

Points: 0
Offline Offline

Posts: 6


« on: April 17, 2010, 01:36:36 »

You can change the time to military time (for the database since you said you're not displaying anything) by changing the date/time format string to "t" for just the hours and minutes (e.g., "20:13" for 8:13 PM) and "T" for the hours, minutes, and seconds (e.g., "20:13:54" for 8:13:54 PM).

I don't know that this SQL query is actually the problem because it's not even using your time's timestamp (hh:mm:ss tt, which would be "03:04:01 AM" and "04:33:21 PM" [I showed both to point out the leading zeros and the fact that it uses 01 - 12 hours instead of 0 - 23 hours]), which I noticed because the query does not use have the seconds portion of your timestamp.  I'd guess the timestamp being used is "hh:mm tt" or maybe just "h:m tt" -- there are no leading zeros in the supplied time to be able to tell which is used.

steroids
Rome apartments
Logged


autopartsyoo
Jr. Member
**

Points: 0
Offline Offline

Posts: 10


« Reply #1 on: January 18, 2011, 03:59:57 »

Share,Gasgoo is a B2B platform for auto parts enterprises to provide including the Pipe Hose,Washing Nozzle,Body Panel,and many other auto parts purchases.
Logged
victoria78
Newbie
*

Points: 0
Offline Offline

Posts: 4


« Reply #2 on: February 02, 2011, 04:25:58 »

It's a great post. You can look few custom essays about this theme and write your own.
Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.7 | SMF © 2006-2008, Simple Machines LLC
TinyPortal v0.9.7 © Bloc
Valid XHTML 1.0! Valid CSS!