Date in MYSQL Fetch and Insert
#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


Messages In This Thread
Date in MYSQL Fetch and Insert - by ToiletDuck - 01.08.2016, 06:21
Re: Date in MYSQL Fetch and Insert - by [cS]Owain - 01.08.2016, 06:24
Re: Date in MYSQL Fetch and Insert - by Vince - 01.08.2016, 09:05
Re: Date in MYSQL Fetch and Insert - by ToiletDuck - 01.08.2016, 09:16

Forum Jump:


Users browsing this thread: 1 Guest(s)