vbdate() function
 

I am not able to retrieve the current time according to user's timezone settings using vbdate()

I am using this, but this always shows 01st of January, 1970:-

Then I use this, and it works fine but always show time 5 hours back.

What wrong am I doing? To insert current time, i have simply created a column of datatype TIMESTAMP and it inserts fine.

Thank You

vbdate function takes UNIX time not in a format such as YYYY-MM-DD HH:MM:SS which is returned by mysql when a column is in date format.

so how to solve the problem ? please explain programmatically. How to insert current date/time so that vbdate() works.

Make the database column an integer(11), use TIMENOW as current value to insert and use vbdate() to make it a displayable date in the users TZ.

Thank you, it works great now.

Is there a way to do just the vice versa of it ? Now I want to convert the displayed form into unix timestamp format and insert it, how should I do it ??

This is the process what I want to do:-

1. Insert date in unix format.
2. Retrieve it in desired format with vbdate().
3. Edit the retrieved date.
4. On submit, convert it in unix timestamp and insert it.

Need help with steps 3 and 4.

Thank You

You can use the mktime() function or better the vbmktime() wrapper.