| User | Post |
|
4:47 am
March 2, 2010
|
jpalacios
Member
| | Spain - Madrid | |
| posts 24 |
|
|
Hi,
Using M3O 3.0.1.1.
Searching on the docs I am unable to find a sample on how to use this custom function.
I have a timestamp and would like to apply a pattern such as DD-MM-YYYY to the date object comming in.
Is this the way to do it?
Thank you,
|
|
|
7:26 pm
March 2, 2010
|
Shigang Liu
Member
| | | |
| posts 54 |
|
|
Hi Jpalacios,
This should depend on the database you are using. Do you mean a date converting function?
Shigang Liu
|
|
|
8:42 am
March 3, 2010
|
jpalacios
Member
| | Spain - Madrid | |
| posts 24 |
|
|
There are several questions in my first post:
1. custom extract function - how do we use it? are there samples?
2. I have a timestamp and I have seen that custom extract function allows you to set a Pattern. Since I dont see how to use this custom function I don´t know if I can apply a pattern such as “DD-MM-YYYY” to a timestamp field.
Thank you,
|
|
|
7:14 pm
March 3, 2010
|
Shigang Liu
Member
| | | |
| posts 54 |
|
|
Hi Jpalacios,
Which extract function do you refer to?
Regards,
Shigang Liu
|
|
|
3:39 am
March 9, 2010
|
jpalacios
Member
| | Spain - Madrid | |
| posts 24 |
|
|
Click on open/close functions drawer
Go down and search for custom function called “Extract”
Regards
|
|
|
8:04 pm
March 9, 2010
|
Shigang Liu
Member
| | | |
| posts 54 |
|
|
Hi Jpalacios,
What's the database type are you using?
Regards
|
|
|
9:23 am
March 25, 2010
|
jpalacios
Member
| | Spain - Madrid | |
| posts 24 |
|
|
|
3:33 am
March 26, 2010
|
Shigang Liu
Member
| | | |
| posts 54 |
|
|
Hi Jpalacios,
The “extract” function you refered to is not what you expect, it's function is to extract a simple element from a complex type using XPath. What you expect is in Datetime Category, you can add some datetime functions using Concatenate function.
|
|
Search 
Forums
Topic RSS 