SQL Column Type
hi , sorry for my bad english..
i have this code in menu: PHP Code:
PHP Code:
In short, I just want to know what type of SQL column is `date`, because it keeps the date and time, the truth would be grateful if I can help :) :3 |
Re: SQL Column Type
SQL COLUMNS:
PHP Code:
PHP Code:
|
Re: SQL Column Type
hello
I tested it, and leaves in 1895 or something like that O.O also wonder if you will not see the problem, so: in the DB appears between LINES date (dd-mm-yy-), and I want to appear between / it so it would appear on the menu, any way? |
Re: SQL Column Type
When you get date from sql, you can replace - with / using replace_all.
Information about dates in sql: http://www.w3schools.com/sql/sql_dates.asp |
Re: SQL Column Type
Quote:
I am a relative novice in SQL, is more or less but would query for a format time set a column? :? Greetings |
Re: SQL Column Type
I'm not sure what do you mean, but if you want to assign value to a "DATETIME" type column, then you can use this:
PHP Code:
"SECOND" can be replaced with other type ( see this list ), but must match type used by time_now and time_in_the_past. |
Re: SQL Column Type
Hello. :)
Shoot me syntax error. Using version 3.3.9.2 PHPMYADMIN remote connection. What i do is convert a column format: %d %b %Y %T: %f From here I took the format: http://www.w3schools.com/sql/func_date_format.asp Greetings |
| All times are GMT -4. The time now is 14:39. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.