Search found 3 matches
- Mon Oct 31, 2011 2:45 pm
- Forum: Tutorials
- Topic: Blog problem with "DATE_FORMAT"
- Replies: 5
- Views: 1428
Re: Blog problem with "DATE_FORMAT"
SELECT 'posts'.'post_id' AS 'id', 'posts'.'post_title' AS 'title', LEFT('posts'.'post_body', 512) AS 'preview', 'posts'.'post_user' AS 'user', DATE_FORMAT('posts'.'posts_date', '%d/%m/%Y %H:%i:%s') AS 'date', 'comments'.'total_comments', DATE_FORMAT('comments'.'last_comment', '%d/%m/%Y %H:%i:%s') A...
- Mon Oct 31, 2011 4:25 am
- Forum: Tutorials
- Topic: Blog problem with "DATE_FORMAT"
- Replies: 5
- Views: 1428
Re: Blog problem with "DATE_FORMAT"
What?
Where do i missed something?
Where do i missed something?
- Sun Oct 16, 2011 10:29 pm
- Forum: Tutorials
- Topic: Blog problem with "DATE_FORMAT"
- Replies: 5
- Views: 1428
Blog problem with "DATE_FORMAT"
Hello. SELECT `posts`.`post_id` AS `id`, `posts`.`post_title` AS `title`, LEFT(`posts`.`post_body`, 512) AS `preview`, `posts`.`post_user` AS `user`, DATE_FORMAT(`posts`.`posts_date`, `%d/%m/%Y %H:%i:%s`) AS `date`, `comments`.`total_comments`, DATE_FORMAT(`comments`,`last_comment`, `%d/%m/%Y %H:%i:...