• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Need to know all the parameters belong to "getPartOfDate"

#1 2012-07-06 11:49:43

ilyasiqbal
Member
Registered: 2012-06-04
Posts: 87

Need to know all the parameters belong to "getPartOfDate"

Hi,

I would like to know all the parameters to calculate different patterns of date, e.g;

DAY, MONTH , YEAR , DAY_OF_MONTH , DAY_OF_YEAR , DAY_OF_WEEK ... and so on.


Thanks

Offline

#2 2012-07-06 11:51:18

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: Need to know all the parameters belong to "getPartOfDate"

Hi

Code:

 "YEAR", "MONTH", "HOUR", "MINUTE", "SECOND", "DAY_OF_WEEK", "DAY_OF_MONTH", 
"DAY_OF_YEAR", "WEEK_OF_MONTH", "DAY_OF_WEEK_IN_MONTH", "WEEK_OF_YEAR",
 "TIMEZONE"

In fact, you can check the code in Repository->Code->Routines->System->TalendDate.

Regards,
Pedro


Only Paranoid Survive.

Offline

#3 2012-07-06 12:06:05

ilyasiqbal
Member
Registered: 2012-06-04
Posts: 87

Re: Need to know all the parameters belong to "getPartOfDate"

Thanks you!

I also want to calculate Quarter, is it possible?

Offline

#4 2012-07-09 06:28:13

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: Need to know all the parameters belong to "getPartOfDate"

Hi

Sorry. For quarter, you have to create a custom routine by yourself.

Regards,
Pedro


Only Paranoid Survive.

Offline

#5 2012-07-09 16:09:17

ilyasiqbal
Member
Registered: 2012-06-04
Posts: 87

Re: Need to know all the parameters belong to "getPartOfDate"

it was working just fine untill i have recently installed norton, that did something wrong with it i think!

Offline

#6 2012-07-09 16:43:43

ilyasiqbal
Member
Registered: 2012-06-04
Posts: 87

Re: Need to know all the parameters belong to "getPartOfDate"

please also check this log:



!SESSION 2012-07-09 15:35:46.763 -----------------------------------------------
eclipse.buildId=unknown
java.version=1.7.0_04
java.vendor=Oracle Corporation
BootLoader constants: OS=win32, ARCH=x86, WS=win32, NL=en
Command-line arguments:  -os win32 -ws win32 -arch x86

!ENTRY org.eclipse.core.resources 2 10035 2012-07-09 15:35:51.824
!MESSAGE The workspace exited with unsaved changes in the previous session; refreshing workspace to recover changes.

!ENTRY org.eclipse.osgi 4 0 2012-07-09 15:35:51.848
!MESSAGE An error occurred while automatically activating bundle org.eclipse.core.resources (330).
!STACK 0
org.osgi.framework.BundleException: Exception in org.eclipse.core.resources.ResourcesPlugin.start() of bundle org.eclipse.core.resources.
    at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:806)
    at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:755)
    at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:370)
    at org.eclipse.osgi.framework.internal.core.AbstractBundle.start(AbstractBundle.java:284)
    at org.eclipse.osgi.framework.util.SecureAction.start(SecureAction.java:417)
    at org.eclipse.osgi.internal.loader.BundleLoader.setLazyTrigger(BundleLoader.java:265)
    at org.eclipse.core.runtime.internal.adaptor.EclipseLazyStarter.postFindLocalClass(EclipseLazyStarter.java:106)
    at org.eclipse.osgi.baseadaptor.loader.ClasspathManager.findLocalClass(ClasspathManager.java:453)
    at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.findLocalClass(DefaultClassLoader.java:216)
    at org.eclipse.osgi.internal.loader.BundleLoader.findLocalClass(BundleLoader.java:393)
    at org.eclipse.osgi.internal.loader.SingleSourcePackage.loadClass(SingleSourcePackage.java:33)
    at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:466)
    at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:422)
    at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:410)
    at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:107)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at org.eclipse.emf.ecore.plugin.EcorePlugin$Implementation.start(EcorePlugin.java:520)
.
.
.
.
continues to make a huge file

Offline

#7 2012-07-10 03:51:31

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: Need to know all the parameters belong to "getPartOfDate"

Hi

You might find solution at topic [Forum, topic 2809] Talend Won't Start.

Regards,
Pedro


Only Paranoid Survive.

Offline

#8 2012-07-10 11:16:08

ilyasiqbal
Member
Registered: 2012-06-04
Posts: 87

Re: Need to know all the parameters belong to "getPartOfDate"

Hi,

The problem was fixed by:

- export my projects
- close and delete TOS
- reinstall TOS
- import my project into workspace

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Need to know all the parameters belong to "getPartOfDate"

Board footer

Powered by FluxBB