Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have following informaiton that I need to import from CSV file, mixed with dates and times as below.
5/1/2012 9:00 |
5/1/2012 9:00 |
5/1/2012 10:30 |
5/2/2012 9:30 |
5/10/2012 14:00 |
5/17/2012 9:00 |
5/21/2012 11:00 |
How can I just import the dates since I cannot use left function...?
thanks for your help!
In your load, use something like
LOAD
...
Date(Daystart(Timestamp#(YOURFIELD,'D/M/YYYY hh:mm'))) as Date,
...
from Table;
In your load, use something like
LOAD
...
Date(Daystart(Timestamp#(YOURFIELD,'D/M/YYYY hh:mm'))) as Date,
...
from Table;
Hi
In your load, use this script
LOAD
...
Date(YOURFIELD,'M/DD/YYYY') as Date,
...
from Table;
Thank you all for your response!
I know I should've checked but here at my work, it is everyday emergency situation!
swuehl, it worked perfect!
thank you both again!