Date in MYSQL Fetch and Insert
#1

Im really confused about this, is there anyway to store a Date that returns to a Timestamp? just like gettime in pawno instead using NOW()?
correct me if im wrong im not a pro.
Reply
#2

PHP код:
select unix_timestamp(`dateColumnName`) as `timestampfrom tableName
Reply
#3

A Unix timestamp can be stored in a normal int column. The function that returns the timestamp is called UNIX_TIMSTAMP().
Reply
#4

Quote:
Originally Posted by Vince
Посмотреть сообщение
A Unix timestamp can be stored in a normal int column. The function that returns the timestamp is called UNIX_TIMSTAMP().
okay i'll try thanksss
Код:
code by [cS]Owain
select unix_timestamp(`dateColumnName`) as `timestamp` from tableName;
i'll use this to fetch unix_timestamp? this will return to timestamp right?

@EDIT:
Nevermind i'll do it in my own way >.>
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)