Splitting a datetime string into a date string and a time string
Hello, I have a small problem: In my database I have a datetime field. Now I need to split the content of that field into a date string and a time string with these formats: date: YYYY/MM/DD time: HH:MM:SS How do I do that? Another thing: I also need to remove / : and spaces from the datetime string. How ? Regards -- ************************ Gitte Wange Jensen System Squid Developer MMManager Aps +45 29 72 79 72 gitte@mmmanager.org ************************
Hi Gitte, assuming you only want to display the date, you could use the fmt-attribute of the dtml-var tag. <dtml-var YourDate fmt="%Y %m %d"> <dtml-var YourDate fmt="%H:%M:%S"> You can also use: <dtml-var "YourDate.strftime('%Y %m %d')"> respectively. HTH Tino Wildenhain --On Donnerstag, 17. Mai 2001 11:29 +0200 Gitte Wange <gitte@mmmanager.org> wrote:
Hello,
I have a small problem: In my database I have a datetime field. Now I need to split the content of that field into a date string and a time string with these formats: date: YYYY/MM/DD time: HH:MM:SS
How do I do that?
Another thing: I also need to remove / : and spaces from the datetime string.
How ?
Regards -- ************************ Gitte Wange Jensen
System Squid Developer MMManager Aps +45 29 72 79 72
gitte@mmmanager.org ************************
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Well I don't know much about it but I'm learning :-) I guess if I do something like: <dtml-var StartDate fmt="%Y/%m/&d"> <dtml-var StartTime fmt="%H:%M:%S"> That will do the displaying. But how do I then make a string (need to use it in a filename) that looks like: YYYYMMDDHHMMSS ? Regards Gitte Wange On Thursday 17 May 2001 13:00, Tino Wildenhain wrote:
Hi Gitte,
assuming you only want to display the date, you could use the fmt-attribute of the dtml-var tag. <dtml-var YourDate fmt="%Y %m %d"> <dtml-var YourDate fmt="%H:%M:%S">
You can also use:
<dtml-var "YourDate.strftime('%Y %m %d')"> respectively.
HTH Tino Wildenhain --On Donnerstag, 17. Mai 2001 11:29 +0200 Gitte Wange <gitte@mmmanager.org>
wrote:
Hello,
I have a small problem: In my database I have a datetime field. Now I need to split the content of that field into a date string and a time string with these formats: date: YYYY/MM/DD time: HH:MM:SS
How do I do that?
Another thing: I also need to remove / : and spaces from the datetime string.
How ?
Regards -- ************************ Gitte Wange Jensen
System Squid Developer MMManager Aps +45 29 72 79 72
gitte@mmmanager.org ************************
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
On Thursday 17 May 2001 13:00, Tino Wildenhain wrote:
Hi Gitte,
assuming you only want to display the date, you could use the fmt-attribute of the dtml-var tag. <dtml-var YourDate fmt="%Y %m %d"> <dtml-var YourDate fmt="%H:%M:%S">
You can also use:
<dtml-var "YourDate.strftime('%Y %m %d')"> respectively.
Well when I try this, I get this error: Zope Error Zope has encountered an error while publishing this resource. Error Type: AttributeError Error Value: 'string' object has no attribute 'strftime' I also tried the other solution, but I got an error saying that the Y wasn't a known format type. Anyone who can help me ? Regards Gitte Wange
HTH Tino Wildenhain --On Donnerstag, 17. Mai 2001 11:29 +0200 Gitte Wange <gitte@mmmanager.org>
wrote:
Hello,
I have a small problem: In my database I have a datetime field. Now I need to split the content of that field into a date string and a time string with these formats: date: YYYY/MM/DD time: HH:MM:SS
How do I do that?
Another thing: I also need to remove / : and spaces from the datetime string.
How ?
Regards -- ************************ Gitte Wange Jensen
System Squid Developer MMManager Aps +45 29 72 79 72
gitte@mmmanager.org ************************
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Hi Gitte, obviously you have to have DateTime objects to manipulate with them. If you convert them to strings beforehand you are not able to use their methods later :) If its a DateTime field in your database and not a string field, the result must be a DateTime object with all its methods, including strftime() If not, you have to instantiate a DateTime object from string like this: DateTime(date_time_as_string) What are you doing with filenames in DTML anyway? If you mean object IDs, you can construct it like this: <dtml-let objID="_.DateTime(time_as_string).strftime('%Y%m%d')"> <dtml-var objID> </dtml-let> Omit this DateTime instantiation if you have a real datetime-object from your database as it should be. Regards Tino Wildenhain --On Donnerstag, 17. Mai 2001 15:02 +0200 Gitte Wange <gitte@mmmanager.org> wrote:
On Thursday 17 May 2001 13:00, Tino Wildenhain wrote:
Hi Gitte,
assuming you only want to display the date, you could use the fmt-attribute of the dtml-var tag. <dtml-var YourDate fmt="%Y %m %d"> <dtml-var YourDate fmt="%H:%M:%S">
You can also use:
<dtml-var "YourDate.strftime('%Y %m %d')"> respectively.
Well when I try this, I get this error:
Zope Error
Zope has encountered an error while publishing this resource.
Error Type: AttributeError Error Value: 'string' object has no attribute 'strftime'
I also tried the other solution, but I got an error saying that the Y wasn't a known format type.
Anyone who can help me ?
Regards Gitte Wange
HTH Tino Wildenhain --On Donnerstag, 17. Mai 2001 11:29 +0200 Gitte Wange <gitte@mmmanager.org>
wrote:
Hello,
I have a small problem: In my database I have a datetime field. Now I need to split the content of that field into a date string and a time string with these formats: date: YYYY/MM/DD time: HH:MM:SS
How do I do that?
Another thing: I also need to remove / : and spaces from the datetime string.
How ?
Regards -- ************************ Gitte Wange Jensen
System Squid Developer MMManager Aps +45 29 72 79 72
gitte@mmmanager.org ************************
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Sorry I don't get this quite, but here's the cold facts :-) I have a datetime column in a MySQL database which I use for this dtml-doc The column is called ls_startdate I need display the startdate in a date field and a time field. I don't do any manipulation with the ls_startdate other than inserting it into my form. When I update the database record, I need to create a filename like ls_startdate.rm - But the filename musn't contain any / : or spaces. So I need to strip these away. But I can't get any of this to work ... please help .. Gitte On Thursday 17 May 2001 15:50, Tino Wildenhain wrote:
Hi Gitte,
obviously you have to have DateTime objects to manipulate with them. If you convert them to strings beforehand you are not able to use their methods later :)
If its a DateTime field in your database and not a string field, the result must be a DateTime object with all its methods, including strftime() If not, you have to instantiate a DateTime object from string like this: DateTime(date_time_as_string)
What are you doing with filenames in DTML anyway? If you mean object IDs, you can construct it like this:
<dtml-let objID="_.DateTime(time_as_string).strftime('%Y%m%d')"> <dtml-var objID> </dtml-let>
Omit this DateTime instantiation if you have a real datetime-object from your database as it should be.
Regards Tino Wildenhain
--On Donnerstag, 17. Mai 2001 15:02 +0200 Gitte Wange <gitte@mmmanager.org>
wrote:
On Thursday 17 May 2001 13:00, Tino Wildenhain wrote:
Hi Gitte,
assuming you only want to display the date, you could use the fmt-attribute of the dtml-var tag. <dtml-var YourDate fmt="%Y %m %d"> <dtml-var YourDate fmt="%H:%M:%S">
You can also use:
<dtml-var "YourDate.strftime('%Y %m %d')"> respectively.
Well when I try this, I get this error:
Zope Error
Zope has encountered an error while publishing this resource.
Error Type: AttributeError Error Value: 'string' object has no attribute 'strftime'
I also tried the other solution, but I got an error saying that the Y wasn't a known format type.
Anyone who can help me ?
Regards Gitte Wange
HTH Tino Wildenhain --On Donnerstag, 17. Mai 2001 11:29 +0200 Gitte Wange <gitte@mmmanager.org>
wrote:
Hello,
I have a small problem: In my database I have a datetime field. Now I need to split the content of that field into a date string and a time string with these formats: date: YYYY/MM/DD time: HH:MM:SS
How do I do that?
Another thing: I also need to remove / : and spaces from the datetime string.
How ?
Regards -- ************************ Gitte Wange Jensen
System Squid Developer MMManager Aps +45 29 72 79 72
gitte@mmmanager.org ************************
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Hi Gitte, dont know of the MySQL DA, but if it is so, it is definitively broken. A DateTime entry schould be returned as DateTime object. Anyway, you can use <dtml-var expr="'ls_'+_.DateTime(ls_startdate).strftime('%Y%m%d%H%M%s')"> in DTML. (Instead of dtml-var to print out you can assign it to some other object) HTH Tino Wildenhain --On Donnerstag, 17. Mai 2001 16:08 +0200 Gitte Wange <gitte@mmmanager.org> wrote:
Sorry I don't get this quite, but here's the cold facts :-)
I have a datetime column in a MySQL database which I use for this dtml-doc
The column is called ls_startdate
I need display the startdate in a date field and a time field.
I don't do any manipulation with the ls_startdate other than inserting it into my form.
When I update the database record, I need to create a filename like ls_startdate.rm - But the filename musn't contain any / : or spaces. So I need to strip these away.
But I can't get any of this to work ... please help ..
Gitte
On Thursday 17 May 2001 15:50, Tino Wildenhain wrote:
Hi Gitte,
obviously you have to have DateTime objects to manipulate with them. If you convert them to strings beforehand you are not able to use their methods later :)
If its a DateTime field in your database and not a string field, the result must be a DateTime object with all its methods, including strftime() If not, you have to instantiate a DateTime object from string like this: DateTime(date_time_as_string)
What are you doing with filenames in DTML anyway? If you mean object IDs, you can construct it like this:
<dtml-let objID="_.DateTime(time_as_string).strftime('%Y%m%d')"> <dtml-var objID> </dtml-let>
Omit this DateTime instantiation if you have a real datetime-object from your database as it should be.
Regards Tino Wildenhain
--On Donnerstag, 17. Mai 2001 15:02 +0200 Gitte Wange <gitte@mmmanager.org>
wrote:
On Thursday 17 May 2001 13:00, Tino Wildenhain wrote:
Hi Gitte,
assuming you only want to display the date, you could use the fmt-attribute of the dtml-var tag. <dtml-var YourDate fmt="%Y %m %d"> <dtml-var YourDate fmt="%H:%M:%S">
You can also use:
<dtml-var "YourDate.strftime('%Y %m %d')"> respectively.
Well when I try this, I get this error:
Zope Error
Zope has encountered an error while publishing this resource.
Error Type: AttributeError Error Value: 'string' object has no attribute 'strftime'
I also tried the other solution, but I got an error saying that the Y wasn't a known format type.
Anyone who can help me ?
Regards Gitte Wange
HTH Tino Wildenhain --On Donnerstag, 17. Mai 2001 11:29 +0200 Gitte Wange <gitte@mmmanager.org>
wrote:
Hello,
I have a small problem: In my database I have a datetime field. Now I need to split the content of that field into a date string and a time string with these formats: date: YYYY/MM/DD time: HH:MM:SS
How do I do that?
Another thing: I also need to remove / : and spaces from the datetime string.
How ?
Regards -- ************************ Gitte Wange Jensen
System Squid Developer MMManager Aps +45 29 72 79 72
gitte@mmmanager.org ************************
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
On Thursday 17 May 2001 16:27, Tino Wildenhain wrote:
Hi Gitte,
dont know of the MySQL DA, but if it is so, it is definitively broken. A DateTime entry schould be returned as DateTime object. Anyway, you can use
<dtml-var expr="'ls_'+_.DateTime(ls_startdate).strftime('%Y%m%d%H%M%s')">
in DTML.
(Instead of dtml-var to print out you can assign it to some other object)
HTH Tino Wildenhain
It works !! Thank you :-) I had missed the one with _.DateTime - sorry ... doing that and I can format the string to only display the date or the time .. Regards, Gitte Wange
--On Donnerstag, 17. Mai 2001 16:08 +0200 Gitte Wange <gitte@mmmanager.org>
wrote:
Sorry I don't get this quite, but here's the cold facts :-)
I have a datetime column in a MySQL database which I use for this dtml-doc
The column is called ls_startdate
I need display the startdate in a date field and a time field.
I don't do any manipulation with the ls_startdate other than inserting it into my form.
When I update the database record, I need to create a filename like ls_startdate.rm - But the filename musn't contain any / : or spaces. So I need to strip these away.
But I can't get any of this to work ... please help ..
Gitte
On Thursday 17 May 2001 15:50, Tino Wildenhain wrote:
Hi Gitte,
obviously you have to have DateTime objects to manipulate with them. If you convert them to strings beforehand you are not able to use their methods later :)
If its a DateTime field in your database and not a string field, the result must be a DateTime object with all its methods, including strftime() If not, you have to instantiate a DateTime object from string like this: DateTime(date_time_as_string)
What are you doing with filenames in DTML anyway? If you mean object IDs, you can construct it like this:
<dtml-let objID="_.DateTime(time_as_string).strftime('%Y%m%d')"> <dtml-var objID> </dtml-let>
Omit this DateTime instantiation if you have a real datetime-object from your database as it should be.
Regards Tino Wildenhain
--On Donnerstag, 17. Mai 2001 15:02 +0200 Gitte Wange <gitte@mmmanager.org>
wrote:
On Thursday 17 May 2001 13:00, Tino Wildenhain wrote:
Hi Gitte,
assuming you only want to display the date, you could use the fmt-attribute of the dtml-var tag. <dtml-var YourDate fmt="%Y %m %d"> <dtml-var YourDate fmt="%H:%M:%S">
You can also use:
<dtml-var "YourDate.strftime('%Y %m %d')"> respectively.
Well when I try this, I get this error:
Zope Error
Zope has encountered an error while publishing this resource.
Error Type: AttributeError Error Value: 'string' object has no attribute 'strftime'
I also tried the other solution, but I got an error saying that the Y wasn't a known format type.
Anyone who can help me ?
Regards Gitte Wange
HTH Tino Wildenhain --On Donnerstag, 17. Mai 2001 11:29 +0200 Gitte Wange <gitte@mmmanager.org>
wrote:
Hello,
I have a small problem: In my database I have a datetime field. Now I need to split the content of that field into a date string and a time string with these formats: date: YYYY/MM/DD time: HH:MM:SS
How do I do that?
Another thing: I also need to remove / : and spaces from the datetime string.
How ?
Regards -- ************************ Gitte Wange Jensen
System Squid Developer MMManager Aps +45 29 72 79 72
gitte@mmmanager.org ************************
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
participants (2)
-
Gitte Wange -
Tino Wildenhain