no timestamp data type in talend?

[Anonymous]

-
It converts it into date types .......... or is there any date pattern like - yyyy-mm-dd hh:mm:ss

[Anonymous]

if your row1 is nullable you can write this :
(row1.value1==null)?null:TalendDate.parseDate("dd/MM/yyyy", row1.value1)
with this formula if value1 is null the expression will return null else it will use the TalendDate.parseDate method
please notice that this formula is usefull if you don't want to have nullPointerException using a method
cheer

[Anonymous]

ok thanks that works execpt that i don't do
(row1.value1==null)?null:TalendDate.parseDate("dd/MM/yyyy", row1.value1) but i do

(row1.value1.equals("")?null:TalendDate.parseDate("dd/MM/yyyy", row1.value1)

[Anonymous]

What is the difference between formatDate and parseDate?

when you press CTRL-SPACE and the list pops up/down, if you click on a formula once, a box should pop up to the side telling you about that formula
but from what i recall, parseDate takes a string value and makes it into a date. formatDate takes a date value and makes it into a string

I am still asking, is timestamp and date are the same thing ?

http://java.sun.com/j2se/1.5.0/docs/api/java/util/Date.html

The class Date represents a specific instant in time, with millisecond precision.

if your row1 is nullable you can write this :
(row1.value1==null)?null:TalendDate.parseDate("dd/MM/yyyy", row1.value1)
with this formula if value1 is null the expression will return null else it will use the TalendDate.parseDate method
please notice that this formula is usefull if you don't want to have nullPointerException using a method
cheer

I'm glad I decided to read through the rest of the topic before posting to use an if statement, since you've already told him how to do it, and cleaner than I was going to suggest

[Anonymous]

Hello ,
I have an issue with MSSQL.
I have a field in a MSSQL table of TIMESTAMP datatype. I didn?t find a corresponding type in Talend
So I used the ?date? type. Unfortunately, it doesn?t load the data in MSSQL table and I have the following error message:
Disallowed implicit conversion from data type datetime to data type timestamp,
table 'IT_Test.Invoice', column 'TS'.
Use the CONVERT function to run this query.
The ?date? type in Talend seems not to be compatible with ?timestamp? in MSSQL server.
Do you have any ideea what to do ?
Thank you very much !
Gabi

[Anonymous]

Hello ,
I have an issue with MSSQL.
I have a field in a MSSQL table of TIMESTAMP datatype. I didn?t find a corresponding type in Talend
So I used the ?date? type. Unfortunately, it doesn?t load the data in MSSQL table and I have the following error message:
Disallowed implicit conversion from data type datetime to data type timestamp,
table 'IT_Test.Invoice', column 'TS'.
Use the CONVERT function to run this query.
The ?date? type in Talend seems not to be compatible with ?timestamp? in MSSQL server.
Do you have any ideea what to do ?
Thank you very much !
Gabi

What's your data looks like in mssql table?
Have you defined the date pattern on schema? For example, here is a data in mssql table 2009-10-12 15:14:10, you should define the date pattern on schema as see my screenshot)
"yyyy-MM-dd HH:mm:ss"
Best regards

shong

[Anonymous]

Hi Shong,
Yes, I've defined exactly like in MSSQL, which is "yyyy-MM-dd HH:mm:ss"
I still get the error :
Disallowed implicit conversion from data type datetime to data type timestamp

[nara1]

i have input table contains:
abc, 20
xyz,45
and i m mapping directly in tmap from input to output and connecting to output table(toraclebulkexec)
now i m getting output like;
"abc",20
"xyz",45
why i m getting double quotes
how can i remove double quotes
help me pls.

[Anonymous]

hi all,
i thought this thread was relevant to ask my question.
i have a string "yyyy-mm-dd HH:mm:ss" for example "2011-04-23 17:23:26". how do i convert this string to date using talend?

[Anonymous]

hi
use TalendDate.parseDate("yyyy-MM-dd HH:mm:ss","2011-04-23 17:23:26")

[Anonymous]

Thanks a lot!