Thanks for a prompt response.

Can you please give any sample code for splitting the values for the function ? Or I would be very grateful if you could provide me...

I need the output as 1215714600 which is an int value of the date converted into milliseconds

Sorry for the confusion.

I need to compare a date value that is stored in the DB via Java like this

--> "" + (cal.getTime().getTime()/1000)

So for comparing at run time i...

Guys,Thanks for the replies.

What i need is an integer representation of a date say 1/9/2008 converted into seconds to be inserted into the database.

The output of a date value (1/9/2008)...

Thanks for a prompt response.

Gayathri, what 'select datediff(ww,'09/01/2008','09/30/2008')' would return is 4 every time for every month.

I need something like in this month i.e September there are actually 5 weeks...

thanks everyone. The script worked fine with the convert function.

I need to convert an nvarchar timezone field to bigint. Can anyone quickly tell me the solution to this as...

wow..this is great.

Thanks John, Michael and Grant for your valuable inputs.

Grant, this is exactly what i need. I have an insert statement which would get fired based on a select...

thanks so much John.

I figured out that i had logged in with a user which didnt have the proper rights.

I can see the JObs tab now !!

Thanks John for a prompt response.

My problem is i am not able to view the 'sql server agent' tab in my object explorer. I have connected to my DB but...

Hello Abhijeet,

Thanks for a prompt response. I dont know what SSIS means. But i will definetely look into it rite now.

Regarding the other part of your reply, I needed that...