FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » Imported messages » comp.lang.php » PDO and date(time)s
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: PDO and date(time)s [message #170567 is a reply to message #170561] Mon, 08 November 2010 16:40 Go to previous message
Matthew Leonhardt is currently offline  Matthew Leonhardt
Messages: 9
Registered: November 2010
Karma:
Junior Member
"Erwin Moller"
<Since_humans_read_this_I_am_spammed_too_much(at)spamyourself(dot)com> wrote in
message news:4cd81d34$0$34849$e4fe514c(at)news(dot)xs4all(dot)nl...
> Hi all,
>
> Until now I have always used adodb for database abstraction.
> (http://www.phplens.com/adodb/)
> Or database specific PHP functions.
> I thought it might be good/fun to try PDO for my next project.
> PDO doesn't offer full database abstraction, just 'database access
> abstraction', according to the specs on www.php.net.
>
> So far, everything in PDO seems to make sense, works as expected, etc,
> except: Where is the date and/or datetime handling?
> It is simply not implemented at all it seems.

I get your frustration, but I think at the root of it, you're talking about
a difference in SQL, not access. IF one RDBMS prefers/requires one date
format, and another prefers something else, there's nothing in PDO that will
help you build syntactically valid SQL for that.

By the same token, there's nothing in PDO that will be able to assist with
the correct syntax for row-limiting between MySQL, MSSQL, Oracle, etc.
(LIMIT, TOP, etc.)

I think what you're really after here is a SQL-abstraction layer. I've
built my own just for this purpose.
[Message index]
 
Read Message
Read Message
Previous Topic: Stats comp.lang.php (last 7 days)
Next Topic: Illegal variable _files or _env or _get or _post or _cookie or _server or _session or globals passed to script.
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 25 22:41:02 GMT 2024

Total time taken to generate the page: 0.04118 seconds