Convert serial date to date string

Hi All,
I have serial dates (39111.501539) in a table and I would like to
convert them to this string format : 1/22/2007 12:31:05 PM. Any
suggestions would be greatly appreciated. The problem exists when I
have to maually load the database tables, I get the serial dates
inserted into the table.
Thank you.
select convert(datetime, 39111.501539)
Returns: 2007-01-31 12:02:12.967
To manage the format you can use substring and various formats, such as:
select stuff(convert(nvarchar(100),convert(datetime, 39111.501539), 101)+
' ' + substring(convert(nvarchar(100),convert(datetime, 39111.501539),
109),13, 20),
20, 4, ' ')
Returns: 01/31/2007 12:02:12 PM
RLF
"Rnt6872" <r_fordjr@.msn.com> wrote in message
news:1172848377.693987.193700@.t69g2000cwt.googlegr oups.com...
> Hi All,
> I have serial dates (39111.501539) in a table and I would like to
> convert them to this string format : 1/22/2007 12:31:05 PM. Any
> suggestions would be greatly appreciated. The problem exists when I
> have to maually load the database tables, I get the serial dates
> inserted into the table.
> Thank you.
>
|||On Mar 2, 10:57 am, "Russell Fields" <russellfie...@.nomail.com> wrote:
> select convert(datetime, 39111.501539)
> Returns: 2007-01-31 12:02:12.967
> To manage the format you can use substring and various formats, such as:
> select stuff(convert(nvarchar(100),convert(datetime, 39111.501539), 101)+
> ' ' + substring(convert(nvarchar(100),convert(datetime, 39111.501539),
> 109),13, 20),
> 20, 4, ' ')
> Returns: 01/31/2007 12:02:12 PM
> RLF

> "Rnt6872" <r_for...@.msn.com> wrote in message
> news:1172848377.693987.193700@.t69g2000cwt.googlegr oups.com...
>
>
> - Show quoted text -
Thank you. Very much!!!!

Convert serial date to date string

Hi All,
I have serial dates (39111.501539) in a table and I would like to
convert them to this string format : 1/22/2007 12:31:05 PM. Any
suggestions would be greatly appreciated. The problem exists when I
have to maually load the database tables, I get the serial dates
inserted into the table.
Thank you.select convert(datetime, 39111.501539)
Returns: 2007-01-31 12:02:12.967
To manage the format you can use substring and various formats, such as:
select stuff(convert(nvarchar(100),convert(datetime, 39111.501539), 101)+
' ' + substring(convert(nvarchar(100),convert(datetime, 39111.501539),
109),13, 20),
20, 4, ' ')
Returns: 01/31/2007 12:02:12 PM
RLF
"Rnt6872" <r_fordjr@.msn.com> wrote in message
news:1172848377.693987.193700@.t69g2000cwt.googlegroups.com...
> Hi All,
> I have serial dates (39111.501539) in a table and I would like to
> convert them to this string format : 1/22/2007 12:31:05 PM. Any
> suggestions would be greatly appreciated. The problem exists when I
> have to maually load the database tables, I get the serial dates
> inserted into the table.
> Thank you.
>|||On Mar 2, 10:57 am, "Russell Fields" <russellfie...@.nomail.com> wrote:
> select convert(datetime, 39111.501539)
> Returns: 2007-01-31 12:02:12.967
> To manage the format you can use substring and various formats, such as:
> select stuff(convert(nvarchar(100),convert(datetime, 39111.501539), 101)+
> ' ' + substring(convert(nvarchar(100),convert(datetime, 39111.501539),
> 109),13, 20),
> 20, 4, ' ')
> Returns: 01/31/2007 12:02:12 PM
> RLF
> "Rnt6872" <r_for...@.msn.com> wrote in message
> news:1172848377.693987.193700@.t69g2000cwt.googlegroups.com...
>
> > Hi All,
> > I have serial dates (39111.501539) in a table and I would like to
> > convert them to this string format : 1/22/2007 12:31:05 PM. Any
> > suggestions would be greatly appreciated. The problem exists when I
> > have to maually load the database tables, I get the serial dates
> > inserted into the table.
> > Thank you.- Hide quoted text -
> - Show quoted text -
Thank you. Very much!!!!

Convert serial date to date string

Hi All,
I have serial dates (39111.501539) in a table and I would like to
convert them to this string format : 1/22/2007 12:31:05 PM. Any
suggestions would be greatly appreciated. The problem exists when I
have to maually load the database tables, I get the serial dates
inserted into the table.
Thank you.select convert(datetime, 39111.501539)
Returns: 2007-01-31 12:02:12.967
To manage the format you can use substring and various formats, such as:
select stuff(convert(nvarchar(100),convert(date
time, 39111.501539), 101)+
' ' + substring(convert(nvarchar(100),convert(
datetime, 39111.501539),
109),13, 20),
20, 4, ' ')
Returns: 01/31/2007 12:02:12 PM
RLF
"Rnt6872" <r_fordjr@.msn.com> wrote in message
news:1172848377.693987.193700@.t69g2000cwt.googlegroups.com...
> Hi All,
> I have serial dates (39111.501539) in a table and I would like to
> convert them to this string format : 1/22/2007 12:31:05 PM. Any
> suggestions would be greatly appreciated. The problem exists when I
> have to maually load the database tables, I get the serial dates
> inserted into the table.
> Thank you.
>|||On Mar 2, 10:57 am, "Russell Fields" <russellfie...@.nomail.com> wrote:
> select convert(datetime, 39111.501539)
> Returns: 2007-01-31 12:02:12.967
> To manage the format you can use substring and various formats, such as:
> select stuff(convert(nvarchar(100),convert(date
time, 39111.501539), 101)+
> ' ' + substring(convert(nvarchar(100),convert(
datetime, 39111.501539),
> 109),13, 20),
> 20, 4, ' ')
> Returns: 01/31/2007 12:02:12 PM
> RLF

> "Rnt6872" <r_for...@.msn.com> wrote in message
> news:1172848377.693987.193700@.t69g2000cwt.googlegroups.com...
>
>
>
> - Show quoted text -
Thank you. Very much!!!!