Welcome to Geeklog, Anonymous Tuesday, November 26 2024 @ 03:32 am EST
Geeklog Forums
date formatting?
tokyoahead
Anonymous
Hi,
what is the internal function to reformat a SQL-timestamp into a Long Date as the user set it?
thanks
what is the internal function to reformat a SQL-timestamp into a Long Date as the user set it?
thanks
11
8
Quote
tokyoahead
Anonymous
I get an array as result?
Got it.
thanks!
Got it.
thanks!
8
11
Quote
tokyoahead
Anonymous
Thanks. This is however for unix-timestamps, not for SQL-Now()-Timestamps... what do you suggest to convert it fastest?
I would only know how to split it with substr...seems not an elegant way to me...
I would only know how to split it with substr...seems not an elegant way to me...
15
12
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by tokyoahead: This is however for unix-timestamps, not for SQL-Now()-Timestamps... what do you suggest to convert it fastest?
Change the SQL request to retrieve it as a Unix timestamp:
Text Formatted Code
SELECT ... UNIX_TIMESTAMP(date) as unixdate WHERE ...Then use the above function on $A['unixdate'].
bye, Dirk
8
11
Quote
tokyoahead
Anonymous
thanks!
I guess the final version of the FAQ-Plugin is done, unless some feature-requests come in...
I guess the final version of the FAQ-Plugin is done, unless some feature-requests come in...
10
11
Quote
All times are EST. The time is now 03:32 am.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content