FUDforum: comp.lang.php » [newbie] datetime issues

Home » Imported messages » comp.lang.php » [newbie] datetime issues

Show: Today's Messages :: Polls :: Message Navigator

[newbie] datetime issues [message #174369]

Wed, 08 June 2011 22:54

Jeff[1]
Messages: 2
Registered: June 2011

Karma:

Junior Member

hi

php 5

I'm trying to construct an sql query where I need to filter between 2 dates.
So how do I dynamically create those datetime values?

Tip: The day value will always be 1 (or 01 ?).

I will dynamically select values from the entire last month.

I tryed this:
convert('2012-'.date('m').'-01 00:00:00',DATETIME)
which gave me syntax error and also I need to some more if testing on year.
So hope there is a better way of doing this

please help me

Report message to a moderator

[Message index]

		[newbie] datetime issues By: Jeff[1] on Wed, 08 June 2011 22:54
		Re: [newbie] datetime issues By: sheldonlg on Thu, 09 June 2011 00:12

Previous Topic:	self-modifying program
Next Topic:	me? pl's visit

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 10:03:21 GMT 2024

Total time taken to generate the page: 0.04218 seconds