Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sureshprpt
Starting Member
33 Posts |
 Posted - 2010-09-20 : 03:19:36
|
| If I downloaded the data from table the date format is Julian format. If I want to change to calendar date, one table is there to convert the Julian date to calendar date. And join table to change the format . The issue is in my table there is two date field is there, and I want to convert both date to calendar date thro query . I cant able to change. The examples are shown Table 1Customer name, Invoice no, Invoice date(Julian), Order date(Julian)Table 2Julian date , related calendar dateThe output format is Customer name, Invoice no, Invoice date(Calendar date), Order date(calendar date)Kindly send the query to download the report in my format Thanks in Advance ByKPSThanks & RegardsSuresh |
|
|
|
|
|
Date conversion